No, it is not working, as below the OFBiz doest not start at all, and without any error, I tried to run verbose mode but there is no error related to this field, and the system stop in the middle of startup And when I delete entity-alias attribute, it gives an error that this attribute is missing, is there any work around like making the entity-alias filed optional??
Thanks ================================== Mamdouh Kaadan -----Original Message----- From: David E. Jones [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 11:24 PM To: [email protected] Subject: Re: query condition in Subtract 2 timestamps So, is this working for you, or what error are you getting? Leaving the attribute blank should be okay, though I don't know that I've tested it... -David On Aug 9, 2006, at 3:12 PM, Mamdouh Kaadan wrote: > Dear David > > > > Thank you for your fast response, I tried to use complex alias, but > the > problem is that the first date is from one table and the other date is > from another table, and entity-alias attribute is required in alias > node, > > I tried the following: > > <view-entity entity-name="IndicatorIssueAndIssueItem" > package-name="org.ofbiz.crm.crm" title=""> > > <member-entity entity-alias="ISS" entity-name="Issue"/> > > <member-entity entity-alias="ISSI" entity-name="IssueItem"/> > > > > > > > <alias entity-alias="ISS" name="issueId"/> > > <alias entity-alias="ISS" name="departmentId"/> > > <alias entity-alias="ISS" name="callingNumber"/> > > <alias entity-alias="ISS" name="dateTimeStarted"/> > > <alias entity-alias="ISS" name="partyId"/> > > <alias entity-alias="ISSI" name="issueItemId"/> > > <alias entity-alias="ISSI" name="caseId"/> > > <alias entity-alias="ISSI" name="specId"/> > > <alias entity-alias="ISSI" name="statusId"/> > > <alias entity-alias="ISSI" name="otherNumbers"/> > > <alias entity-alias="ISSI" name="urgent"/> > > <alias entity-alias="ISSI" name="currentDeptId"/> > > <alias entity-alias="ISSI" name="additionalRemark"/> > > <alias entity-alias="ISSI" name="lineTypeId"/> > > <alias entity-alias="ISSI" name=" firstActionDate"/> > > <alias entity-alias="ISSI" name=" SolvedDate"/> > > > > <alias entity-alias="" name="firstActionDifference"> > > <complex-alias operator="-"> > > <complex-alias-field entity-alias="ISSI" > field="firstActionDate"/> > > <complex-alias-field entity-alias="ISS" > field="dateTimeStarted"/> > > </complex-alias> > > </alias> > > <alias entity-alias="" name="SolvedDifference"> > > <complex-alias operator="-"> > > <complex-alias-field entity-alias="ISSI" > field="SolvedDate"/> > > <complex-alias-field entity-alias="ISS" > field="dateTimeStarted"/> > > </complex-alias> > > </alias> > > <view-link entity-alias="ISS" rel-entity-alias="ISSI"> > > <key-map field-name="issueId"/> > > </view-link> > > </view-entity> > > > > Can you help me please, thanks > > > > ================================== > > 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] > >> > >> > >> > >> > >> > > >
