Searching for variablename used in PromptSet
Article ID: 89569
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:
Component:
Resolution
Detailed Description and Symptoms
Solution
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.
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>
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='<value>')
Us the Variable in a job or run the test button to display the results.
Select OH_Name from OH where OH_Idnr=(select JPOV_OH_Idnr from JPOV where JPOV_Value='<value>')
Us the Variable in a job or run the test button to display the results.
Feedback
Yes
No
Powered by
