Re: [Exist-open] Finding unique items

[Adam R. <ada...@de...>]

Something like this maybe -

for $type in distinct-values(/event/@type) return
 /event[@type eq $type][position() eq 1]




-----Original Message-----
From: exi...@li... on behalf of Jasen Jacobsen
Sent: Fri 07/03/2008 14:01
To: exi...@li...
Subject: [Exist-open] Finding unique items
 
First, thanks to all for the help on the variable parameters.  I got
some good techniques that I will be applying.

In my little scenario, I have a bunch of <event>s with some
attributes, one being type.  Type can hold several different values,
say "Wedding, Concert, Banquet, Birthday Party".  Lets say I have a
set of <event>s and I want one event of each type. So something like:
<event type="Wedding"/>
<event type="Concert"/>
<event type="Wedding"/>
...

And I want the result set to have one <event> for each value of "type".

I tried sorting the <event>s with:

let $result :=
    for $temp in $input
    order by $temp/@type
    return $temp

And then checking for things without matching preceding siblings a la:
let $result := $result[not(@type = preceding::@type)]

but that doesn't seem to be working.

- Jasen.

P.S. It really seems I'm looking for general XQuery help as much as
eXist help.  Is there a good site with these sorts of How-Tos for
XQuery?

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Exist-open mailing list
Exi...@li...
https://lists.sourceforge.net/lists/listinfo/exist-open