MRVS values not updating in sc_item_option table

[Ruchi Kumari1]

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 .

[Bhavya11 · Accepted solution]

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

[Bhavya11 · Accepted solution]

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

[Ankur Bawiskar · Accepted solution]

@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.

[Ruchi Kumari1]

Hi @Ankur Bawiskar @Bhavya11 ,
Thanks for your response. I am aware of the table where the answers get stored but based on my requirement can we not fetch the details from sc_multi_row_question_answer table and update in sc_item_option table against the variable ?
The exact use case is I am generating multiple RITMs from one request. Each RITM belongs to different user selected on form for list collector type field. On the catalog form, once multiple users are selected, i am storing values specific to each user in MVRS in multiple rows.
On submit, default RITM generated is currently showing all the values submitted in MRVS and other RITMS generated from script are not showing values at all.
As per my understanding it's because it's taking values ultimately from sc_item_option table.
So i was wondering if I could take values from sc_multi_row_question_answer table and update in sc_item_option_table ? Would this any violation from best practice stand point ?

Image 1 is for script generated RITMs and Image 2 is default RITM. I have selected 2 users on my catalog form.

[Ankur Bawiskar]

@Ruchi Kumari1 

that's how MRVS and normal variables are stored.

When it comes to normal variables either stand-alone or variables within Single row variable data is stored in these 2 table sc_item_option_mtom and sc_item_option

They are inter linked with each other.

The MRVS table data is stored in these 2 tables sc_multi_row_question_answer and sc_item_option

So the table sc_item_option is common in both the places.

In 1st screenshot if it's not required then hide that MRVS as it's generated from script.

You can check if the MRVS has value or not. if not then hide it using onLoad

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