Thanks very much. I did go with the DynamicViewEntity
> On Aug 15, 2016, at 1:25 PM, Taher Alkhateeb <[email protected]> > wrote: > > 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 >>
