AnsweredAssumed Answered

Where to store lookup data

Question asked by DanielGates628573 on May 4, 2018
Latest reply on May 4, 2018 by DanielGates628573

Hello,

 

I was just wondering where everyone stores there lookup data ..

 

e.g. currently we have a variable object containing a list of job names with their corresponding code that needs executing.  The job names are displayed in a prompt set which when selected activates a generic workflow executing the code also stored in the static variable. This works fine but I guess any new jobs that need adding would require the variable object to be deployed to all clients that need to run the new job.

 

Would this be better stored in a sql table somewhere? Is it recommended/possible to create tables in the automic backend database and then access them using SQLI variables. Or have another seperate database to be used specifically for such interactions?

 

Any advice would be appreciated...

 

Cheers,

 

Dan

Outcomes