[XQuery Talk Mailing List Archive Home] [By Date] [By Thread] [By Subject] [By Author] [Recent Entries] [Reply To This Message]

Group by - problems!!!

Meeru Enterprise meeruenterprise at gmail.com
Mon Jan 17 14:03:29 PST 2005


xquery group by
Hi All,
I have got the hang of xquery however, just have one shortcoming!
please have a look and see what i am doing wrong, been banging my head
for a few hours and cant seem to get it, here goes,

let $doc := doc("Big.xml")
for $a in distinct-values($doc//OTY)
let $uniquename := for $g in $a
                      where $g = $a
                      return $g
let $occurences := for $g2 in $doc//OTY
                       where $g2[text() eq $a]
                       return $g2
let $links := for $x in $doc
                       where $x//OTY = $a
                  return $x//AID[@id]
    return
      <result>
        <name>{ $uniquename }</name>
        <occurences>{ count($occurences) } </occurences>
        <links>{ $links) } </links>
      </result>
  }

Basically all i am trying to do is to get a unique element name along
with its number of occurences , that all is perfect and works 100%.
Then i want to find out which record that appeared in and get the
corresponding record id($links, as of now it matches all records for
all unique elements) , thats where i am failing, need a fresh set of
eyes to see this, i am going absolutely mad!!!! thank you in advance!


PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2011 All Rights Reserved.