Re: query condition in Subtract 2 timestamps

["David E. Jones" <jo...@undersunconsulting.com>]

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: +963-94-222763
>
> Office :  +963-94-222222   Ext: 2288
>
> E-mail:MKaadan@areeba.com.sy
>
>
>
>
>