Data Manipulation

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
su2
Reply | Threaded
Open this post in threaded view
|

Data Manipulation

su2
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-
Reply | Threaded
Open this post in threaded view
|

Re: Data Manipulation

Yoke Power
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.
>
>
su2
Reply | Threaded
Open this post in threaded view
|

Re: Data Manipulation

su2
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 <shuchi@pexsupply.com> 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.
>
>