How to create a Stored Query to display all change orders with workflow tasks in pending status?
book
Article ID: 52928
calendar_today
Updated On:
Products
CA IT Asset ManagerCA Software Asset Manager (CA SAM)ASSET PORTFOLIO MGMT- SERVERSUPPORT AUTOMATION- SERVERCA Service Desk Manager - Unified Self ServiceCA Service Desk ManagerCA Service Management - Asset Portfolio ManagementCA Service Management - Service Desk Manager
Issue/Introduction
Create a scoreboard node to display Change Orders with workflow tasks in Pending status.
Environment
Service Management 17.x
Resolution
Please
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: