Searching for variablename used in PromptSet

Document ID : KB000089569
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Searching for variablename used in PromptSet
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.
 
.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='<value>')


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