search cancel

Searching for variablename used in PromptSet

book

Article ID: 89569

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Searching for variablename used in PromptSet

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

Detailed Description and Symptoms
A name or object used in a Condition isn't searchable using the regular search because it isn't it's own object.

For example, if a User is trying to find in what Conditions is 'TESTFILE' used or when *OWN is used instead of an actual Agent name.
 

<Please see attached file for image>

.png

Solution
To search for a Variablename in Condition, create a SQLI Variable using the following SQL Statement:

Select OH_Name from OH where OH_Idnr=(select JPOV_OH_Idnr from JPOV where JPOV_Value='&lt;value>')


Us the Variable in a job or run the test button to display the results.