Hello Ahmad, If I understand your question correctly then my recommendation is to use org.apache.ofbiz.entity.util.EntityQuery. This class allows for method chaining which makes it look like SQL but without having to write raw SQL. The benefit is that you remain independent of the underlying database while at the same time using familiar select(..).from(...).where(...) SQL-like structures.
On Sun, Apr 2, 2017 at 10:27 AM, Ahmad Al ajarmeh <aalajar...@bi-bst.com> wrote: > Hello Dears , > > > > kindly there is Any way To write native query in ofbiz ? > > > > Thank you. > > > > > > *Best Regards,* > > > > Ahmad Alajarmeh > > Java Developer > > > > [image: Description: Logo for Office-4] > > > > [image: Description: bi email-3-02] > > > > P.O.Box 3516 Amman, 11821 > > The Hashemite Kingdom of Jordan > > *Tel.* +962 (6) 556 2620 > > *Mob (Jordan).* +962 78 836 5695 > > [image: Description: bi email-3-04] > > [image: Description: bi email-3-05] > > /biict > > @biict > > > > >
