Extract the catalog item names on a variables table or on a question_choice table.

[Insider]

Hello Seekers,

I am trying to extract a report.

Extract the catalog item names on a variables table or on a question_choice table where these variable or question is included in a variable set.

When i am directly extracting a report, i am getting empty fields for variables where these are included in any variable sets.

So, how to extract a report in this case where i can get the catalog item names of the variable or question choices.

Please help

insider

[Anurag Tripathi]

Hi ,

from the variables (item_option_new) table is pretty simple, there is a field called cat Item and you can use that.

For Questuion Choice you can open the table in list view -> Right click on the header and configure list layout 

Then

Dot walk to Question as shown above and from there do another dot walk to cat item as shown below.

Save and Done.

[Insider]

Hello Anurag,

This i already did for report extract.

In this case lets consider variables list, we will get few empty catalog_item fields because the variable is a part of variable set. I need a solution for that situation?

Please help

insider.