RE: query condition in Subtract 2 timestamps

Posted by Mamdouh Kaadan-2 on
URL: http://ofbiz.116.s1.nabble.com/query-condition-in-Subtract-2-timestamps-tp141298p141301.html

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:[hidden email]]
Sent: Wednesday, August 09, 2006 6:55 PM
To: [hidden email]
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: [phone]

>

> Office :  [phone]   Ext: 2288

>

> E-mail:[hidden email]

>

>

>

>

>