You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Jacques Le Roux <ja...@les7arts.com> on 2017/04/02 10:00:31 UTC

Re: FW: write native query in ofbiz

Hi Ahmad,

It's not recommended and you need to be sure you can't use OFBiz EntityQuery rather for maintenance reason. But in case you really need it it's there

Remember: use the OFBiz user ML, if you are not yet subscribed it's at http://ofbiz.apache.org/mailing-lists.html

Jacques


Le 02/04/2017  11:19, Ahmad Al ajarmeh a crit :
> Thanks you a lot,
>
> I want to use  native query ; Because there are some special modifications i have it ,then
>
> I want to use  native query to send direct SQL to database
>
> Best Regards,
>
> Ahmad Alajarmeh
> Java Developer
>
>
>   
>
>
>   
> P.O.Box 3516 Amman, 11821
> The Hashemite Kingdom of Jordan
> Tel.                     +962 (6) 556 2620
> Mob (Jordan).   +962 78 836 5695
>
>
> /biict
> @biict
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: Jacques Le Roux [mailto:jacques.le.roux@les7arts.com]
> Sent: Sunday, April 2, 2017 11:12 AM
> To: dev@ofbiz.apache.org
> Subject: Re: write native query in ofbiz
>
> 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.*+962(6) 556 2620
>>
>> *Mob (Jordan).*  +962 78 836 5695
>>
>> 	
>>
>> Description: bi email-3-04
>>
>> Description: bi email-3-05
>>
>> 	
>>
>> /biict
>>
>> @biict
>>
>>
>> 	
>> 	
>> 	
>> 	
>> 	
>>
>