How to create report for which incidents the survey is not triggered

[Surendra6]

Hello,

We have a requirement for which incidents the survey assessment instances are not triggered. we understood it by creating database view and please help to give the where clause for the both incident and asmt_assessment_instance tables in the database view.

Regards,

Surendra

[Surendra6]

Hi team,

Please someone help this requirement.

Thanks!!

[Community Alums · Accepted solution]

Hi @Surendra6 ,

I tried your problem in my PDI and it works for me 

I created Database view and added two tables a.) Incident b.) asmt_assessment_instance

Added where clause on assessment table like assessment.task_id = incident.sys_id and also checked left join to asseessment table 

Result: 

Please mark my answer correct and helpful if this works for you

Thanks and Regards 

Sarthak