By the way, you may need to add "collection()" in front of "//a" also or you'll probably get the same error. My guess is that 1.0 is set as the default XQuery version for stored queries (if indeed that can be separately set...)
Evan On 10/10/11 9:36 AM, "Evan Lenz" <[email protected]> wrote: >Hi Betty, > >I'm not sure, but I'm guessing it's a 1.0 vs. 1.0-ml issue. > >Try adding collection() before the "//c" in your first example, since >that's probably what you're intending. The implicit addition of >"collection()" when a context node isn't defined is specific to MarkLogic. >On the other hand, when a context node is defined, it starts from the >document node of the same document as the context node, not the entire >collection. > >Your second example shouldn't work because you're trying to use a path >expression on a simple value ($a). > >Evan Lenz >Software Developer, Community >MarkLogic Corporation >http://developer.marklogic.com > > > >On 10/10/11 8:52 AM, "Betty Harvey" <[email protected]> wrote: > >>The following works perfectly in CQ: >> >>for $a in distinct-values(//a/b) >>let $c := //c[d = $a]/descendant::era:e >>order by $a >>return >><tr> >><td>{$a}</td> >><td>{$c}/></td> >></tr> >> >>The same query in stored XQuery gives an error "Expression depends on the >>context where none is defined". >> >>I have tried multiple XPath approaches but I haven't been able to get the >>XPath statement to move above the currently document in the collection: >> >>for $a in distinct-values(collection()/a/b) >>let $c := $a/ancestor::a/../descendant::c[d = $a]/descendant::era:e >>order by $a >>return >><tr> >><td>{$a}</td> >><td>{$c}/></td> >></tr> >> >>What is the best approach for doing joins within MarkLogic within a >>collection? It is probably something really simple that I am not >>finding. >> >>TIA! >> >>Betty >> >>/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ >>Betty Harvey | Phone: 410-787-9200 FAX: 9830 >>Electronic Commerce Connection, Inc. | >>[email protected] | Washington,DC XML Users Grp URL: >>http://www.eccnet.com | http://www.eccnet.com/xmlug >>/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\\/\/ >>Member of XML Guild (www.xmlguild.org) >> >> >> >>_______________________________________________ >>General mailing list >>[email protected] >>http://developer.marklogic.com/mailman/listinfo/general > >_______________________________________________ >General mailing list >[email protected] >http://developer.marklogic.com/mailman/listinfo/general _______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
