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 KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

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

Environment

Service Management 17.3

Resolution

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\')