database view asmt_assessment_instance_question, asmt_assessment_instance, Task

[mregragui_ext]

Hello community,

I have posted this question more than three times, but I still haven't received any solutions. If someone can help me resolve this problem, I would greatly appreciate it.

The requirement is to have a list view that includes all the tasks of the instance, with all possible states. If a ticket has a survey, I need to display it next to its task. I created a database view that combines these three tables, but I can only see the tasks that have a survey. I also want to see the tickets that don't have a survey with an empty survey field.

Here is my current database view:

[Peter Bodelier]

Hi @mregragui_ext,

You haven't gotten a solution, because it isn't possible.

Best option I can think of is to create a survey field on the task table, where you fill the survey for the task.

[mregragui_ext]

@Peter Bodelier 

Do i need to create a reference field on the asmt_instance_question?

[Peter Bodelier]

I would only do this on task.

[mregragui_ext]

@Peter Bodelier 

i have create a reference field on task table that point on asmt_instance_question it display emty