Hi Pros,

Am new to Ofbiz and am having a hard time coming up with an EntityQuery
statement that can represent this simple SQL statement

"SELECT DISTINCT l.sd, l.sv, r.dt, l.pn FROM LL l, Res r WHERE l.td = ? AND
l.sd = r.id ORDER BY l.sd, l.sv"

LL and Res represent 2 independent entity models in the Ofbiz entity engine.

I will appreciate any help or pointers to documentation on how to do this

Thanks,
Chenzo

Reply via email to