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

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

[Tanushree Maiti]

Hi @Alon Grod 

Form Level

• item_option_new: Stores individual variable definitions whether they belong to a standard catalog item or a variable set.
• item_option_new_set: Stores the metadata configuration and definition of the variable sets themselves.

Post Submission and Runtime Data

• sc_item_option: Holds the actual answers or values submitted for a catalog item.
• sc_item_option_mtom: Acts as a mapping (many-to-many) table that connects the saved variable values to a specific parent record like a requested item (RITM).
• sc_multi_row_question_answer: Stores the data specifically collected from multi-row variable sets (MRVS), where each row creates an individual record.