RE: query condition in Subtract 2 timestamps

[Mamdouh Kaadan-2]

Dear David

 

I'm sorry because I didn't reply till now, but I tried your changes on
my version of OFBIZ, and it didn't work, so I upgraded my version to the
last version, and it took a long time.

Your modification is working very well.

Thanks you for your effort and your cooperation.

 

Kind regards

 

==================================

Mamdouh Kaadan

 

 

-----Original Message-----
From: David E. Jones [mailto:[hidden email]]
Sent: Wednesday, August 09, 2006 6:55 PM
To: [hidden email]
Subject: Re: query condition in Subtract 2 timestamps

 

 

Use a view-entity with a complex-alias field (either in an XML view-

entity definition, or in a DynamicViewEntity).

 

For details about how to do stuff like this you might find the  

recently completed advanced framework training package from Undersun  

helpful. There are details here:

 

http://www.undersunconsulting.com/ecommerce/control/product/ 

~category_id=USC_PROMO/~product_id=OFBADVFWKPKG

 

-David

 

 

On Aug 9, 2006, at 11:43 AM, Mamdouh Kaadan wrote:

 

> Dear all

>

>

>

> How can I make SQL query in OFBiz based on subtract 2 timestamps,

>

> By example:

>

> select * from table

>

> where FIRST_ACTION_DATE- Second_ACTION_DATE <'+00 12:00:00.000000'

>

>

>

> How can I make the previous statement using the delegator methods??

>

>

>

> Thanks in advance

>

> ==================================

>

> Mamdouh Kaadan

>

> Software Engineer

>

> IT - Application

>

> Areeba SYRIA

>

> Mobile: [phone]

>

> Office :  [phone]   Ext: 2288

>

> E-mail:[hidden email]

>

>

>

>

>