Question Re: Group by in transaction in Product Lifecycle Management Q&A

Group by in transaction

Former Member — Thu, 13 Sep 2012 20:24:17 GMT

Hi All,

I am getting 600+ records for each three Tags for a month and doing group by by using a xslt in Transaction.Currently transaction is taking so much time to execute.

Is there any other way to do Group by in transaction without using xslt?

Thanks & Regards

Manisha

Re: Group by in transaction

Former Member — Fri, 14 Sep 2012 10:43:27 GMT

Hi Manisha,

I tried one action Crosstab under XML Functions, it is not exactly group by clause.

you can configure XML columns on which you want to group like tag and month in crosstab action.

After that you can filter your crosstab output data at DrilldownDepth=2 (depends on no. of columns you configured in crosstab).

in result of filter you will get output on tag and month combination.

suppose in your XML you have three columns Tag_Name, Month, Value

(T1, Sep, 10),

(T1, Sep, 20),

(T1, Sep, 15)

Than after applying above logic you will get output like (T1,Sep,45)

Hope it helps!!

Thanks & Regards,

Manoj Bilthare

Re: Group by in transaction

Former Member — Fri, 14 Sep 2012 12:49:23 GMT

Thanks Manoj.I shall try this and let you know.

Regards

Manisha

Re: Group by in transaction

Former Member — Sat, 15 Sep 2012 19:51:12 GMT

Thanks Manoj.Its working fine.

Regards

Manisha