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.
>
>
