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

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