Hello all,
I currently have a customer satisfaction report which points the Metric results table. I have most of the fields I require, however, how do I get the comments field added into this report?
The below columns is what I have to show me the Task number, Name, etc but I just need to add the comments field to make this complete:
there is this OOTB task assessment detail database view which covers something similar and joins the related assessment tables so that you can see the survey question responses
you can try to see that and replicate for your task extended table
When you do Try It it shows like this
If my response helped please mark it correct and close the thread so that it benefits future readers.
Thanks for the prompt responses. @SumanthDosapati , I require the string value from the question table to capture the responses as well as the string value from the results table (which has a different result).
@Ankur Bawiskar , it appears a database view is the correct approach here, however, I am quiet new to using this process. I have attempted to create a view as shown below, but I believe I may need some assistance in joining the 2 tables so I can see the results in my report. Can you please confirm if I am missing any tables and what the join values would be based on the below? I understand the common factor in both these tables is the Instance field so perhaps I need to reference this?:
there is this OOTB task assessment detail database view which covers something similar and joins the related assessment tables so that you can see the survey question responses
you can try to see that and replicate for your task extended table
When you do Try It it shows like this
If my response helped please mark it correct and close the thread so that it benefits future readers.
