[MarkLogic Dev General] Best way to search collection from Stored XQuery

[Evan Lenz]

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" <Evan.Lenz at marklogic.com> 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" <harvey at 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. |
>>harvey at 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 at developer.marklogic.com
>>http://developer.marklogic.com/mailman/listinfo/general
>
>_______________________________________________
>General mailing list
>General at developer.marklogic.com
>http://developer.marklogic.com/mailman/listinfo/general