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:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 6:55 PM To: [email protected] 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: +963-94-222763 > > Office : +963-94-222222 Ext: 2288 > > E-mail:[EMAIL PROTECTED] > > > > >
