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

Surendra6
Tera Contributor

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

1 ACCEPTED SOLUTION

Community Alums
Not applicable

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

SarthakKashyap_0-1715882964090.png

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

 

Result: 

SarthakKashyap_1-1715883044115.png

 

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

Thanks and Regards 

Sarthak

 

 

 

View solution in original post

2 REPLIES 2

Surendra6
Tera Contributor

Hi team,

 

Please someone help this requirement.

 

Thanks!!

Community Alums
Not applicable

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

SarthakKashyap_0-1715882964090.png

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

 

Result: 

SarthakKashyap_1-1715883044115.png

 

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

Thanks and Regards 

Sarthak