Grouping and Distinct items

Condor76 · May 22nd, 2007, 01:09 AM

Hello,

Is there a way to get Group items in a node as well as distinct using 1 Xpath expression?

Grouping:
/dataroot/Book[not(Title=preceding-sibling::Book/Title)]/Title");

Distinct:
/dataroot/Book[Title='value']/Title");

Is there a way to combine both of this into 1? I have an XML doc that is sorted and I need to do the above to it.

Thanks!

mhkay · May 22nd, 2007, 06:08 AM

/dataroot/Book/Title[.='value'][1]

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Condor76 · May 22nd, 2007, 11:06 AM

Thank you Michael for your help.

I tried your suggestion but I'm having trouble getting it to work:

Code:

titleList = sortedDocument.SelectNodes("/dataroot/Book/Title[Type='" + typeSelected.SelectedValue + "'][1]");

I also tried:

Code:

/dataroot/Book/Title[Type='" + typeSelected.SelectedValue + "'][1]/Title

and

Code:

/dataroot/Book/Title[Type='" + typeSelected.SelectedValue + "']/Title

any thoughts as to why it didn't work?

mhkay · May 22nd, 2007, 11:29 AM

Given that you haven't shown us your source document, it could be any number of things. Perhaps there's a namespace issue.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Condor76 · May 22nd, 2007, 11:52 AM

You are correct Michael... sorry about that.

Here's what the XML structure looks like:

Code:

<?xml version="1.0" encoding="utf-8"?>
<dataroot>
<Book xmlns:od="urn:schemas-microsoft-com:officedata" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
        <ID>47</ID>
        <Availability>2006-04-18T00:00:00</Availability>
        <Title>
            <Value>Title x</Value>
        </Title>
        <Type>Educational</Type>
    </Book>
  <Book xmlns:od="urn:schemas-microsoft-com:officedata" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
        <ID>65</ID>
        <Availability>2007-09-26T00:00:00</Availability>
        <Title>
            <Value>Title y</Value>
        </Title>
        <Type>Educational</Type>
    </Book>
  <Book:od="urn:schemas-microsoft-com:officedata" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
        <ID>68</ID>
        <Availability>2007-09-26T00:00:00</Availability>
        <Title>
            <Value>Title y</Value>
        </Title>
        <Type>Fiction</Type>
    </Book>
.
.
.
</dataroot>

joefawcett · May 23rd, 2007, 01:11 AM

So you need to declare the prefix-uri ,mappings. How you do that depends on which parser you are using. Look at the relevant documentation for "namespace mappings" or similar. If it's MSXML for example search on "SelectionNamespaces", with .NET it's NamespaceManager.

--

Joe (Microsoft MVP - XML)