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.
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.
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%')