How can I do addition 2 columns when amountyType = SHIPPING_CHARGES and addition of 2 rows when amountType = SALES_TAX ?
Is it possible to do it in java or .bsh ? Yoke Power wrote: > > This kind of Filtering of data can be done using <entity-condition> if you > are using minilang. Following is the usage of the <entity-condition> tag > > > <entity-condition entity-name="OrderHeaderAndRoleSummary" > list-name="orderInfoList"> > <condition-list combine="and"> > <condition-expr field-name="partyId" operator="equals" > env-name="parameters.partyId"/> > <condition-expr field-name="roleTypeId" operator="equals" > env-name="parameters.roleTypeId"/> > <condition-expr field-name="orderTypeId" operator="equals" > env-name="parameters.orderTypeId"/> > <condition-expr field-name="statusId" operator="equals" > env-name="parameters.statusId"/> > <condition-expr field-name="orderDate" operator="greater-equals" > env-name="parameters.fromDate" > ignore-if-null="true"/> > <condition-expr field-name="orderDate" operator="less-equals" > env-name="parameters.thruDate" > ignore-if-null="true"/> > </condition-list> > <select-field field-name="partyId"/> > <select-field field-name="roleTypeId"/> > <select-field field-name="totalGrandAmount"/> > <select-field field-name="totalSubRemainingAmount"/> > <select-field field-name="totalOrders"/> > <order-by field-name="partyId"/> > </entity-condition> > > - YOKEPOWER > > On Mon, Sep 28, 2009 at 4:29 PM, su2 <[email protected]> wrote: > >> >> Hello All, >> >> I have constructed the SQL and got all the result but I am not sure how >> to >> manipulate these data ? >> is there any recorder set kind of thing. >> >> From my 1st SQL, I am getting entire data with 3 types of amountType >> (PROMOTION_ADJUSTMENT, SALES_TAX & SHIPPING_CHARGES). >> >> Now I need to add 2 columns when amountyType = SHIPPING_CHARGES and I >> need >> to add 2 rows when amountType = SALES_TAX >> >> I really appreciate your help. >> >> Thank you. >> Su- >> -- >> View this message in context: >> http://www.nabble.com/Data-Manipulation-tp25652390p25652390.html >> Sent from the OFBiz - User mailing list archive at Nabble.com. >> >> > > -- View this message in context: http://www.nabble.com/Data-Manipulation-tp25652390p25662831.html Sent from the OFBiz - User mailing list archive at Nabble.com.
