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

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,