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- |
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 <[hidden email]> 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. > > |
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 ?
|
Free forum by Nabble | Edit this page |