This document provides the stored query to display all change orders with workflow tasks in pending status.
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\')
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\')