The CreatorCon Call for Content is officially open! Get started here.

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,