how do report on multi row variable set

[MMKK]

Hi All,

I wanted to know if there is any way that i can report on Multi row variable set variables. I really need this feature and i see that there is some limitation.

Please share any alternate way.

[Kevin133]

Hello Samarendra,

It's impossible to troubleshoot why your not getting values. It could be a million things.

First makes sure you are using an MRVS for a sc_req_item. This database view is for catalog items only. not record producers. Are you getting results if you don't filter down to a specific Item? If no, then the issue is your database view. Make sure you don't have any typos in your Where Clause

The "Question" column is the variable name and "Value" is the value

[Samarendra Naya]

Hello Kevin,

Thanks for replay,

I have now able to get the records but all are multiple records for same request and I am  unable find all the variable name(catalog variables & variable set variables) to select as I want all the variables as row.

In my catalog item, there are some variables which for end user to fill at  the time of submit the request and the multi row variable set is available for fulfiller(task) to fill at the time of fulfil the task. 

 Thanks,

Samarendra Nayak

[Samarendra Naya]

Hello Kevin,

I want to create the database view with sc_task table, as my MRVS is available in task and an engineer will fill those  at the time of closing this task.

I have tried as below, Please suggest.

Thank,

Samarendra Nayak

[Samarendra Naya]

[Kevin133]

 Your variables are linked to the requiest item, not the task, so I would keep the sc_req_item table in there. Get the sc_task table by linking it to the sc_req_item table.

Build your DB view as I describe in my initial reply to this question (making sure you have the sc_req_item row). then modify your sc_task entry at like 105 where the where clause to your sc_task entry is something like: tas_request_item = sci_sys_id (Not tested, you you may need to tweek)