Ticket with state different to closed not appear in my database view

[mregragui_ext]

Hello community,

I have create a database view between 3 tables to have all the tickets with all the states append to survey result but i am just getting tickets that in state closed or closed complete.

here is the database that i made 

[Brad Bowman]

Only tickets in those states have a survey, so if you want all of the tickets regardless if they have an assessment instance you need to make Left join = true on the task table entry, and switch the Where clause to task_sys_id = ai_trigger_id

[mregragui_ext]

Hi @Brad Bowman  

i have done what you tell me but when i filter with instance is empty i get no result so i only have the tasks with a survey and i have checked the left join in task

[Brad Bowman]

I would start with the task table since you want all records from that, so more like this:

[mregragui_ext]

@Brad Bowman  sorry but i still don't have tickets without instance survey or instance survey empty