Hi Valery, I believe the EntityQuery can only operate on one entity/table. To create the above statement I would suggest to:
- Use the from method which takes a DynamicViewEntity argument and build your entity dynamically. For more on that read on the DynamicViewEntity ( https://ci.apache.org/projects/ofbiz/site/javadocs/org/ofbiz/entity/model/DynamicViewEntity.html ) - Create a view entity which joins your entities and then run the EntityQuery against it. I hope this helps, Cheers! Taher Alkhateeb On Mon, Aug 15, 2016 at 4:30 PM, valery chenzo <[email protected]> wrote: > 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 >
