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

but unable add the task_assessment_details table in database views. Please suggest me the right way

Mounika30_0-1711088986502.png

 

Hi @Mounika30 ,

 

Please refer the below and create the database view. And create a report on the database view table to  get the necessary fields like ctask number, assignment group, view surveys etc.

 

Please mark the answer helpful/solution accepted if it solves your query.

 

Thanks,

Hi @Mounika30 ,

 

Please mark helpful or solution accepted if it solved your query.

 

thanks,

still, didnt met the requirement . please could you create a database view for asmt_assessment_instance

asmt_metric

task table.

mhegde1
Kilo Sage

Hi @Mounika30 ,

 

It is for Request the survey would trigger not for task, so the above solution would work for Requests as well.( that is to report "asmt_assessment_instance" or "asmt_metric" tables.

 

Please correct me if I am wrong @AndersBGS . 

 

Please mark my answer correct/helpful if it solves your issue.

 

thanks,