x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 3 replies
  • Subscribers 74 subscribers
  • Views 414 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
jcbaker

Can I Identify Workflow State within Advanced Find?

Posted By

We instituted Opportunity workflows recently, and I am having trouble identifying Opportunities that are not in their proper workflow state. Ideally I could create an Advanced Find for this so that my users could go in and progress the Opportunity through to the correct State, but short of examining each one by one I don't know how to do this... any suggestions?

Parents
  • 0

    Try: -

    SELECT Oppo_PrimaryCompanyId,Oppo_Description,WkSt_Name

    FROM opportunity

    LEFT JOIN WorkflowInstance on oppo_opportunityId = wkin_currentRecordId AND WkIn_CurrentEntityId = 10

    LEFT JOIN Workflowstate on WkIn_CurrentStateId = wkst_stateId AND wkst_deleted IS NULL

    WHERE oppo_deleted IS NULL

Reply
  • 0

    Try: -

    SELECT Oppo_PrimaryCompanyId,Oppo_Description,WkSt_Name

    FROM opportunity

    LEFT JOIN WorkflowInstance on oppo_opportunityId = wkin_currentRecordId AND WkIn_CurrentEntityId = 10

    LEFT JOIN Workflowstate on WkIn_CurrentStateId = wkst_stateId AND wkst_deleted IS NULL

    WHERE oppo_deleted IS NULL

Children
No Data

*Community Hub is the new name for Sage City