In which table the values of variable sets are stored

[Alon Grod]

In which table the values of variable sets are stored

[Danish Bhairag2 · Accepted solution]

Hi @Alon Grod ,

• Variable Set Definitions (item_option_new_set): Stores the metadata configuration of the variable sets themselves.

• Variables (item_option_new): Stores individual variable definitions whether they belong to a standard catalog item or a variable set.

• Submitted Values (sc_item_option / question_answer): Stores the actual submitted answers linked to a requested item (RITM) or task record.

• Multi-Row Variable Sets (sc_multi_row_question_answer): Data for multi-row variables (MRVS) is stored in the sc_multi_row_question_answer table. Each row of MRVS is a record in this table.

Thanks,

Danish Bhairagdar

[VaibhavP5059517]

Are the records stored in the "sc_multi_row_question_answer" table temporary or permanent?

[Dr Atul G- LNG]

Hi @Alon Grod 

In ServiceNow, runtime values for standard variables and single variable sets are stored in the Options (sc_item_option) table and linked via the Variable Ownership (sc_item_option_mtom) table. Multi-row variable set (MRVS) rows and values use a separate dedicated table: Multi Row Question Answers (sc_multi_row_question_answer)

[Tejas Adhalrao]

hi @Alon Grod ,

• sc_item_option – Stores the variable values.
• sc_item_option_mtom – Maps the variable values to the corresponding Requested Item (RITM).
• item_option_new – Stores the variable definitions (questions/variables).

If you're trying to retrieve the values for a specific RITM, you would typically query sc_item_option_mtom

Regards,
Tejas

If you found my solution helpful, please mark it as Helpful and Accept Solution.