How to create a Stored Query to display all change orders with workflow tasks in pending status?

Document ID : KB000052928
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Description:

This document provides the stored query to display all change orders with workflow tasks in pending status.

Solution:

If you would like to list the change orders which has workflow task in pending status based upon the logged in users group, please use the below query:

group.[group]group_list.member IN (@cnt.id) AND id.[chg]workflow.status IN (\'PEND\')

Figure 1

To display all Change Orders which has tasks in pending status irrespective of the group please use the below query:

id.[chg]workflow.status IN (\'PEND\')

Instructions:
Please Update This Required Field