AnsweredAssumed Answered

PromptSet Values in database

Question asked by SamahSohrab607228 on Nov 18, 2013
Latest reply on Nov 4, 2014 by Jean-FrancoisAnctil606475

Hello,

I'm trying to query the underlying database to find the values of prompt elements for a set of jobs. I decided to start with a specific job, but when I look in the OPUD table, not all the values for that job's promptset are listed there. The value I'm looking for is a text field. The promptset has 16 values, 7 text fields, 6 radio buttons, and 3 number choices. The values that show up when I query the OPUD table are 5 text fields values, and 2 radio values. I'm looking for the rest (or more specifically, one of the other text fields).

Can someone tell me what tables I should be looking at to see all the values that a job has stored for it's promptset?

Also is there a better description of the tables and what is contained in them, than the data dictionary that is provided by Automic?

Thanks

Outcomes