Searching for variablename used in PromptSet

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

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.