catalog item variable stored in the catalog item table

chandan2212
Tera Contributor

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 

11 REPLIES 11

Hi @chandan2212 ,


Can you check if there are any catalog UI policies or client scripts acting on those variables? Particularly if the Clear Variable Value is checked in the ui policy or written inside catalog client script.


Please accept my solution and give it a thumbs up if it's helpful for you.

Regards,
Prashant

Syed14
Mega Guru

sc_item_option: This table stores the individual variables defined for catalog items.

sc_item_option_mtom: This is a "many-to-many" table that links the sc_req_item records to the sc_item_option records.

See this link: https://www.servicenow.com/community/developer-forum/catalog-item-variables/m-p/2999655#:~:text=In%2...