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]
