- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2025 12:58 AM - edited 07-01-2025 12:59 AM
Hi,
I have a MRVS (3 variables/columns) in my catalog which has value in it on submit of catalog.
Once catalog is submitted and RITM is generated, RITM displays the MRVS with values but in the backend (sc_item_option) table is empty for these 3 variables/columns in MRVS.as a result values in sc_item_option_mtom table is also empty.
As per my understanding, sc_item_option table stores values in variables as submitted from catalog. Other fields which are outside MRVS does display their values in the backend table.
Is this is an expected behaviour for MRVS variables to be empty in backend ? I need to use these values from the table to implement some logic .
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2025 01:26 AM
Hi @Ruchi Kumari1 ,
if you want to fetch value of MRVS then you need to check sc_multi_row_question_answer table it holds value of Multi row Question Answers.
Note:
Variables are stored - item_option_new
Variable set are stored - item_option_new_set
Once RITM is submitted data for single row variable set are stored in - Variable Ownership [sc_item_option_mtom]
Data for MRVS stored in MRVS Multi Row Question Answer [sc_multi_row_question_answer]
For record producer once submitted data is stored in - question_answer
If this information proves useful, kindly mark it as helpful or accepted solution.
Thanks,
BK
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2025 01:44 AM
data for MRVS is stored in sc_multi_row_question_answer
For normal variables which are stand-alone or part of Single row variable set data is stored in sc_item_option_mtom
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2025 05:16 AM
Another way is
1) Your 1st RITM has 2 MRVS rows so you created 2 RITMs
2) each of your RITM can have only 1 row for MRVS
Example: RITM001 has 2 MRVS rows Abel and Beth
You are creating RITM002 for Abel and RITM003 for Beth
Then in RITM002 MRVS you can add 1 row for Abel
Then in RITM003 MRVS you can add 1 row for Beth.
While creating RITM you can extract rows and set the MRVS.
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2025 10:18 PM
Hope you are doing good.
Did my reply answer your question?
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader