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 @Ankur Bawiskar for the information. This has helped me progress and I have been able to create a database view required to get the data. The view now looks like this:
When generating a report pointing to this table, I am able to get the required data, however the report results show duplicate entries for the same ticket. How can I make it so it only shows unique RITMs?
