OQL query syntax

1
I have a data-set and a entity hierarchy A-B-C, A containing a grouping in table X and B containing a grouping in table Y (so X:A = Y:B = 1:n). I need a field in the dataset from every entity so fA, fB, fC, fX and fY. Please help me with the OQL syntax FROM statement. Thanx.
asked
2 answers
1

The way I've seen, is there are two ways to kind of use OQL. 1) Using references explicitly (your 'join tables' Mendix creates) which is probably the best.

Example

SELECT COUNT(*)
FROM Loan.ResponsibleParty rp
INNER JOIN rp/Loan.LoanHeader_Responsible_Party/Loan.LoanFile lf
INNER JOIN lf/Loan.Bucket_LoanHeader/Loan.Bucket lb

The other way kind of mirrors Microsoft's T-SQL where you specify how to join (just use TSQL syntax).

Also, there's some good documentation here: https://world.mendix.com/pages/releaseview.action?pageId=11436153

EDIT: The multiplicity in my example is rp (*) -> (1) lf (*) -> (1) lb

answered
0

It seems to work, however no data found but that is probably my mistake. No not probably but surely. Thanx!

answered