catalog item variable stored in the catalog item table

[chandan2212]

Hi All,

Can you tell me once the  catalog item is created(sc_req_item) table, in which table all the variables values are stored in the ServiceNow tables.

Thanks and Regards,

Chandan 

[G Ponsekar]

Hi @chandan2212 ,

M2M table to request item
sc_item_option_mtom.request_item=sc_req_item.sys_id

M2M table to variable
sc_item_option_mtom.sc_item_option=sc_item_option.sys_id

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

Thanks, GP

[Shruti]

Hi,

Single row variables are stored in question_answer table

Multi row variables are stored in sc_multi_row_question_answer table

[Ankur Bawiskar]

@chandan2212 

The information is stored in 3 different tables

-> Normal Variables and Variables within Single Row Variable set

-- Stored in Variable Ownership (sc_item_option_mtom) and Options (sc_item_option)

-> Multi row variable set

-- Stored in Multi Row Question Answer(sc_multi_row_question_answer) and Options (sc_item_option)

If my response helped please mark it correct and close the thread so that it benefits future readers.

[chandan2212]

Hi Sir,

Cat item and value showed in the emplty and sysid in the sc_item_option table , Please let me know how to reslove the issue.

Thanks and Regards,

Chandan