Automic Workload Automation

  • Private Community

  • 1.  Search for values in Variables & Prompts Tab

    Posted Jun 06, 2018 05:01 PM

    Anyone have a query to pull values from the variables & prompts tab? I'm looking for a value that I suspect is contained in some object's v & p tab, but I don't know which one.  It would be really nice if this search were available in the GUI (on v10 now, but upgrade to v12.1 in progress).

     

    If this was answered somewhere already, I apologize but I was unable to locate it.



  • 2.  Re: Search for values in Variables & Prompts Tab

    Posted Jun 11, 2018 05:09 PM

    We've got file paths and file names defined in these and no one kept track of those values, so now people ask about a file and we have to hope and guess our way to an answer.



  • 3.  Re: Search for values in Variables & Prompts Tab
    Best Answer

    Posted Jun 11, 2018 05:43 PM

    I would use something like this:

     

    SELECT OH_NAME FROM OH WHERE OH_IDNR IN (SELECT OV_OH_Idnr FROM OV WHERE OV_Value like '%file.txt%')



  • 4.  Re: Search for values in Variables & Prompts Tab

    Posted Jun 12, 2018 10:23 AM

    Perfect, thanks!