Report to show Incident survey responses with assignment group

Mounika30
Kilo Sage

Report to show Incident survey responses with assignment group

-just need the list of records with INC number and assignment group

15 REPLIES 15

Hi 

Next to the task , i want to show ctask number as well

Mounika30_2-1710925292088.png

 

 

Hi @Mounika30 ,

 

What do you refer to when you state that you want to see the ctask? Do you mean that task should show the incidents and ctask = incidents task or?

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Hi @Mounika30 ,

 

If you want to show the ctask number as well then you need to create a database view between the "asmt_assessment_instance" and task table or "asmt_metric" and task table.

 

thanks,

Hi 

Next to the task , i want to show ctask number assignement group as well 

so , a Data base view is need to be for task assessment details ,sc_req_item, and sc task tables

Mounika30_0-1711084266003.png

Mounika30_1-1711084266002.png

 

Hi @Mounika30 ,

 

yes , Thats correct. 

 

Database view between Asmt_assessment_instance , sc_req_item and sc_task tabels have to be created.

 

thanks,