DanielGates628573

List of named objects

Discussion created by DanielGates628573 on Dec 18, 2017
Latest reply on Dec 18, 2017 by Wolfgang_Brueckler_1288
Hello,

I would like to populate a prompt set drop down list with a list of suffixes from a set of objects in the client.

So for example, for all variable objects like 'VARIABLE_ENVIRONMENT_VALUES_XXXX' I want to extract out the XXXX part and insert this into another variable object to be read by the prompt set.

e.g. 
VARIABLE_ENVIRONMENT_VALUES_MXVV
VARIABLE_ENVIRONMENT_VALUES_MXYY

Would give me:
99ya3k2eokgm.png

Do I need to write sql to interrogate the Automic sql database for this or is there another way?

Cheers,

Dan

Outcomes