How to get case variable details from table Case [sn_customerservice_case]?

[Fabiann]

Hello,

In our CSM portal, our partner have designed a form available in Service Catalog, when a user is submitting a request via this form, it creates a case.

And in the case, all the variables captured in the front end form are present in the tab Variable Information:

 

I am trying to find a way to have one of this field in a report but cannot find a way.

As  from the table Case [sn_customerservice_case] I cannot find any related column..?

Many thanks for your help in advance

Kind regards

[Balaji Jagannat]

You can get these variables from question_answer table. Refer this article for your solution options. 

https://community.servicenow.com/community?id=community_question&sys_id=88c00b65db98dbc01dcaf3231f96...

[MrMuhammad]

If there is no link then you need to create a database view to join two table fields together and then report on that.

Please navigate to Database view docs by clicking the link below.

https://docs.servicenow.com/bundle/orlando-platform-administration/page/use/reporting/concept/c_Data...

Please mark this accepted & helpful if it answered your question.

Thanks & Regards,
Sharjeel

[Tyler Herman]

Hi Fabiann,

You can report on these variables, here's how:

1. Create a new list report on the sn_customerservice_case table.
2. Click "Choose columns"
3. Scroll down and select the "Questions [+]" column and then click the  button.
4. A new window will appear where you can select the catalog item used to generate the case, click on it.
5. The window will disappear and you will now be looking at the column selection window with a list of variables on the selected catalog item.
6. Click on the desired variable and then click the  button to move it to your selected column list.
7. Click the OK button and now run or save your report.

Hope this helps!