I'm trying to create a view where I can see tasks for demand and tasks for the project table. I works fine when using on only a joint view between the demand task , demand and project table. But, when I try adding the project task table to the equation, the reports shows empty. Not sure if it's the order, or the where clauses, I've tried multiple combinations and it continues to show up empty. The last attempt was using an or operator || , but doesn't seem to like it either.
Any suggestion would be greatly appreaciated.
Thank you.
One thing that you could do is to start with task, filter it to demands and projects then left join demands' tasks to task and left join projects' tasks to task. However that would give you only task fields for demand and project. You could also left join demand and project to the base task. It should work. Something like:
The only problem is that you will be getting each demand and project as many time as they have child tasks. So if a demand has 5 demand tasks, you will get that demand 5 times. But that is valid for any such select, it's a logic problem, not a SN/DB View problem.
Apologies for the late response Janos, fell off my radar, appreciate the quick response and detail. I proceeded to create the following data base view:
Now, the problem that I'm having is that I lost the demand task short description, or at least it shows up empty , for this new scenario where I'm introducing demand and projects tasks. I'm only looking for the first task that contains "gateway" within the short description. I will also want the project task short description that matches "kick off", which also shows up empty.
When I do this same exercise only for demand and task (this data base view does not include project tasks), it works:
I do get the output:
