Grouping and selecting Distinct items

[Mchine34]

I have created an xslt that sorts the following xml on node: Path

XSLT:
[HTML]
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>

<xsl:template match="/">
<xsl:apply-templates/>
</xsl:template>

<xsl:template match="Root">
<Root>
<xsl:for-each select="./*">
<xsl:sort select="./Path" order="ascending" data-type="text"/>
<xsl:copy-of select="." />
</xsl:for-each>
</Root>
</xsl:template>

<xsl:template match="Book">
<xsl:copy-of select="." />
</xsl:template>

<xsl:template match="*">
<xsl:copy-of select="." />
</xsl:template>

</xsl:stylesheet>
[/HTML]

I would like to next grab node Path where Audience equals a value passed unto it:

[HTML]/Root/Book[Audience='" + selection.SelectedValue + "']/Path[/HTML]

Finally,

Grab distinct values of Path:

[HTML]/Root/Book[not(Path=preceding-sibling::Book/Path)]/Path[/HTML]

Is there a way to incorporate these last two XPath's onto my XSLT?

A sample of my XML:
[HTML]
<Root>
<Book>
<ID>85</ID>
<Title>One</Title>
<Product>
<Value>Exchange Hosted Services (EHS)</Value>
</Product>
<Path>
<Value>Build Skills</Value>
</Path>
<Audience>Implementer</Audience>
</Book>
<Book>
<ID>3</ID>
<Title>Two</Title>
<Product>
<Value>Exchange Server 2007</Value>
</Product>
<Path>
<Value>Build Skills</Value>
</Path>
<Audience>Implementer</Audience>
</Book>
<Book>
<ID>3</ID>
<Title>Three</Title>
<Product>
<Value>Exchange Server 2007</Value>
</Product>
<Path>
<Value>All</Value>
</Path>
<Audience>Sales</Audience>
</Book>
</Root>[/HTML]


Thank you in advance!

[dorinbogdan]

Welcome to TheScripts TSDN....

It may require to use xsl:param passed from code onto XSL.
If coding for C#, see this link.
For Javascript, see this link.

[Mchine34]

Thanks for your recommendations dorinbogdan. I'm doing this using C#. I really liked the link you sent "If coding for C#".

The reason I posted this question is because I'm having trouble doing this in C# alone. By this I mean:

/Root/Book[Audience='" + selection.SelectedValue + "']/Path

and

/Root/Book[not(Path=preceding-sibling::Book/Path)]/Path

in 1 XPath expression.

I figured this can be done easier using XSLT. Would you agree with this?

Thanks.

[dorinbogdan]

Yes it's easier, and the XPath syntax is the same, you can use the same XPath expression, just replace the C# variable with the XSL param within the XSL template.
See this reference for XPath syntax.
Also it's helpful to have an overview over this XSL tutorial.