GenericSortFilter.xsl unable to filter data in inline transformation.

[Former Member]

Hi,

I am working on MII 12.0

I need to filter an xml output of transaction. So I am using the inline transformation.

I am passing filter column name, filter column value, filter exp and filter type.

But the data is not getting filtered.

When I am applying inline transformation for sorting, the data is getting sorted.

When I apply generic sort filter action block in transaction to filter the data, itu2019s getting filtered.

Need help on this.

Thanks

Vishal Jadhav

[Former Member]

Why use the XSL approach? Use the GenericSortFilter action in BLS instead.

[Former Member]

Hi,

We can use generic sort filter in BLS.

But MII has provided XLS transformation facility.

I checked the xsl file used in genericsortfilter case.

A code fragment is below

<xsl:when test="$FilterType = 'lt'">

<xsl:choose>

<xsl:when test="$TestValue &lt; $FilterValue">Y</xsl:when>

<xsl:otherwise>N</xsl:otherwise>

</xsl:choose>

As you can see , instead of checking the FilterExp , it is checking the FilterType.

That's where the problem lies.

I made the necessary changes and now its working fine through the XSL transformation.

Regards,

Vishal Jadhav

[jcgood25]

What error are you receiving on the screen?

What error is appearing in the NetWeaver logs?

[Former Member]

Their is no error.

The data is coming.But it is not filtered.

Ex : -

I implemented a filter say get all record where col1 > 10

Then all the data is coming. That filter condition is checked at all.

Also i need to know how we can use 'OR' condition in xsl transformation.

Like get all the records where col1 > 10 and col1 < 20