Possiblity to have OUTER JOIN among report entities
We need possiblity to do LEFT OUTER JOIN among Entities.
I give you and example of an objective for having it:
I need a report that shall show all the UOM of an Account where the usages were not loaded.
I tried to do it starting from the Rate Plan Charge data source but I don't have the usages
I tried to do it starting from the Usages data source but than it filters on all UOM where we had usages.
What I need in pseudo SQL is the following
FORM ACCOUNT INNER JOIN CHARGES
LEFT OUTER JOIN USAGES
WHERE USAGES.VALUE IS NULL
We need it to check that our interface worked fine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.