reporting on record producer variables

[si21]

Hi experts,

We have a record producer that creates a HR case.

Users wanted to report on the variables  present on the record producer.

What is the best way to achieve this. 

Also can we report for MRVS variables?

TIA

[SAI VENKATESH]

Hi @si21 

Record producer variable store in "Question Answer (question_answer)" table.

You can use the the "table_sys_id" field to fetch the data to it's related data on the referring table.

Thanks and regards

Sai Venkatesh

[AndersBGS]

Hi @si21 ,

You can utilize the table where record producer insert the record and then report on variables. The variables for the specific record producer can then be selected. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders