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

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 Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager CA Service Management - Asset Portfolio Management CA 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:

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