Showing survey question and responses in single column in incident survey report

[svirkar420]

Hello Developers,

I have a requirement in my project where I need to show the report for incident survey in such a way that it should look like a rating given like for Q1. The response for the Q1 for survey should be seen below the Q1 column.

In simple words here Q1 will be the table header and response submitted to that Q1 should be the table content which should be seen below the Q1 column.

I have attached the screenshot for this with this post. Please find it.

Your inputs will be valuable.

Best Regards,

Saurabh V.

[Dr Atul G- LNG]

Hi @svirkar420 

Now my doubt is that,

1. How do I configure the joins the tables using clause? (can you show it in PDI if possible as I am also trying to do it in PDI).

Atul: Here are few examples:

https://www.servicenow.com/community/developer-forum/how-to-create-database-views-for-reports-genera...

https://www.servicenow.com/community/cmdb-forum/creating-a-report-using-database-views/m-p/2437676 or 

refer the response from @JackieZhang 

2. Which report type will be best pivot table or multilevel pivot table.

Atul: It will be Multilevel Pivot.

3. How do I fetch the data of database view into the reports.

Atul: When you create the report, make sure to use the database table name, and then create the report based on that.

[Peter Farkas]

Hi,

There are two db views for the surveys.

1. For the Legacy surveys there is task_survey_detail which I found in this KB

2. The task_assessment_detail joins 4 tables and might be useful in this scenario. (I couldn find it in KB or DOCS)

Hope it helps,

Peter