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.
