MRVS values not updating in sc_item_option table

Ruchi Kumari1
Tera Expert

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 .

2 ACCEPTED SOLUTIONS

Bhavya11
Kilo Patron

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

 

 

 

 

View solution in original post

Ankur Bawiskar
Tera Patron
Tera Patron

@Ruchi Kumari1 

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

6 REPLIES 6

@Ruchi Kumari1 

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Ruchi Kumari1 

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader