problem with xml type query

[Former Member]

Hi All

I have created one transaction in logic editor and my output is in one xml.Now i have called this in query template.

There i am facing problem for xml type query.I need to take total of rows from my xml and than want to perform some calculation.

Could anybody help me in this.

Thanks

Thomas

[Former Member · Accepted solution]

Hi Thomas

For this type of calculation you have to call xml type query.

After specify xml source. now you give path of your stylesheet folder and select subtotal xslt.

This xslt will provide you total of rows that you desire.

For further calculation you can go in transform tab and select proper inline transform (calculator or MultiCalculator.Here you can give your expression.

Hope this way will help you.

Regards

Ramshanker

[Former Member]

Hi Thomas

If u have a xml query and want to calculate the number of rows in the o/p , the easiest way is to use X-Path to calculate.

Use and assignment block to have the following expresiion to assign to a local variable -:

queryname{count (Rowsets/Rowset/Row)}

[Former Member]

Hi Thomas,

You can solve the problem as mentioned above by ram shanker...

The other way is..

1. Select crosstab from xml functions in the business logic services.

2. Add this at the end of your transaction.

3. Link the exact column by which you want the total of

rows

4. Make this as a output for your transaction.

5. Open the xacute quey and call this transaction

6. For further calculations go the transform tab and select appropriate stylesheets..

Hope this also help you....

Regards,

Kishore kumar P.S.