Show survey responses for new questions

[sujan0119]

I have a survey in ServiceNow. Earlier, it used to have 3 questions. To report on the survey response, the team clicks on the related link "View responses in Rows", and it shows the questions in columns and responses in rows in a different table starting with "u_metric". We deactivated 2 questions from the survey and added 2 new questions to the survey, but the new questions are not populating when clicking on the related link.

How to show the new questions similarly to the previous one? Please help.

[Voona Rohila]

Hi @sujan0119 

I have updated similar requirement recently.

Once you click the "View responses in Rows" button, It opens a list of records( which is a database view) 

you need to open that database view(Right click -> configure -> database View) and change the conditions in your 'where clause' for 'asmt_metric_result' tables accordingly.

Try and let us know if you are able to fix it.

Ref links - https://www.servicenow.com/docs/bundle/zurich-servicenow-platform/page/administer/survey-administrat...

[sujan0119]

Hi @Voona Rohila ,

Thanks for the response,

I followed the same process and created two new view table on  'asmt_metric_result' in the database view and updated the where clause with the sys ids of the 4th and 5th questions. I got the label as "string Value" for both the questions as per the screenshot below.

We want to show the question names instead of the Label "String Value". Please help.

[Voona Rohila]

Perfect.

Yes so for next step Navigate to 'Labels' and add a filter table name is 'your database view name' and check existing ones and create a new label for the same for these 2 Fields.

[Voona Rohila]

Go to 'sys_documentation' table for Field labels and follow above steps