Happy Business Starts Here

0 Kudos

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
SELECT ACCOUNT.*,CHARGES.UOM
FORM ACCOUNT INNER JOIN CHARGES
LEFT OUTER JOIN USAGES
WHERE USAGES.VALUE IS NULL

We need it to check that our interface worked fine.

Thanks