I want to know all the table names for all the variables and variable sets used in a catalog item and and there respective values

[Samarendra Naya]

Dear All,

I want to know all the table names for all the variables and variable sets used in a catalog item and and there respective values. I have created a catalog item with 15 variables and 2 variable sets(1 single row , 1 multi row).

One of my client asking the direct table names for those to pull the data using TABLE API and prepare dashboard for that using some third party analytics. 

Can you please help

Thanks

Samarendra Nayak

[Ankur Bawiskar]

Hi,

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

Regards
Ankur