Where are Catalog Item Variables stored for a catalog item?

[Steve42]

I have a catalog item that I would like to find out where the variable values are stored, or are they only stored in memory until the REQ and RITM get created then destroyed.  Asking as I would not like to regex the out of the description field if possible.

[Allen Andreas]

Hi,

They are stored on the sc_item_option_mtom table.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Allen Andreas]

Hello,

I just wanted to check-in on this.

If my reply above helped guide you correctly, please mark that reply as Helpful & Correct.

Thank you!

[Allen Andreas]

Hi @Steve42 - It's been a few years now, haha, but I saw this popping up in my notifications due to others marking my original reply as Helpful. Let me know if my original reply helped answer your question or guide you correctly. If so, please consider marking it as Accept Solution.

Take care! 😀

[Mark Roethof]

Hi there,

Not sure what you mean here. When do you exactly want to do something with the variables?

If it's onChange, when filling out your Catalog Item, etc.. You can use g_form.getValue etc.. Submitted Catalog Items, you could reach your variables for example with Business Rule through using current.variables.your_variable.

The actual tables where submitted variables are stored... for sc_cat_item multiple:

sc_item_option
sc_item_option_mtom
sc_multi_row_question_answer

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list