write native query in ofbiz

[Ahmad Al ajarmeh]

Hello Dears ,

 

kindly there is Any way To write native query in ofbiz ?

 

Thank you.

 

 

Best Regards,   Ahmad Alajarmeh Java Developer
P.O.Box 3516 Amman, 11821 The Hashemite Kingdom of Jordan	Tel.                     [phone] Mob (Jordan).   [phone]			/biict @biict

 

 

[Pierre Smits]

Please explain what you expect others to understand when you use the term
'native query'.

Best regards,

Pierre Smits

ORRTIZ.COM <http://www.orrtiz.com>
OFBiz based solutions & services

OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/

On Sun, Apr 2, 2017 at 9:27 AM, Ahmad Al ajarmeh <[hidden email]>
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.*                     [phone]
>
> *Mob (Jordan).*   [phone]
>
> [image: Description: bi email-3-04]
>
> [image: Description: bi email-3-05]
>
> /biict
>
> @biict
>
>
>
>
>

[taher]

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 <[hidden email]>
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.*                     [phone]
>
> *Mob (Jordan).*   [phone]
>
> [image: Description: bi email-3-04]
>
> [image: Description: bi email-3-05]
>
> /biict
>
> @biict
>
>
>
>
>

[Jacques Le Roux]

I guess you mean SQL query, then here you go

https://demo-trunk.ofbiz.apache.org/webtools/control/EntitySQLProcessor

Look for SQLProcessor class in Java code

But please use rather user ML for such questions, see why here http://ofbiz.apache.org/mailing-lists.html
You will get a better support and it's more fair to share with everybody

The wider the audience the better the answers you might get

Thanks

Jacques


Le 02/04/2017 à 09:27, Ahmad Al ajarmeh a écrit :

>
> Hello Dears ,
>
> kindly there isAny wayTo writenative queryin ofbiz ?
>
> Thank you.
>
> *Best Regards,*
>
> Ahmad Alajarmeh
>
> Java Developer
>
>
>
> Description: Logo for Office-4
>
>
>
> Description: bi email-3-02
>
>
>
> P.O.Box 3516 Amman, 11821
>
> The Hashemite Kingdom of Jordan
>
>
>
> *Tel.*[phone]
>
> *Mob (Jordan).*  [phone]
>
>
>
> Description: bi email-3-04
>
> Description: bi email-3-05
>
>
>
> /biict
>
> @biict
>
>
>
>
>
>
>
>