In which table the values of variable sets are stored

[Alon Grod]

In which table the values of variable sets are stored

[Danish Bhairag2]

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

[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)