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" <har...@eccnet.com> 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. | >har...@eccnet.com | 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 >General@developer.marklogic.com >http://developer.marklogic.com/mailman/listinfo/general _______________________________________________ General mailing list General@developer.marklogic.com http://developer.marklogic.com/mailman/listinfo/general
