Re: query condition in Subtract 2 timestamps

Posted by David E Jones-2 on
URL: http://ofbiz.116.s1.nabble.com/query-condition-in-Subtract-2-timestamps-tp141298p141303.html


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]
>
>
>
>
>