Hi Cerstin,
On 26.03.2013, at 16:07, Cerstin Elisabeth Mahlow cerstin.mahlow@unibas.ch wrote:
Hi,
I got stuck with an XQuery, could you please help?
I have data like this:
<collection> <entry> <q>[text() contains text ('Johann' ftand 'Ballhorn') distance at most 5 words ordered][self::*:p or self::*:q]</q> <id>12345</id> <p>bey welchen die Verbesserungen durch Johann Ballhorn öfter vorkommen als man glauben sollte.</p> </entry> <entry>… </collection>
All I want to get back is the <p> node with the content of the <q> node applied to <p> using ft:mark, i.e., the node with highlighting like this:
<p>bey welchen die Verbesserungen durch <mark>Johann</mark> <mark>Ballhorn</mark> öfter vorkommen als man glauben sollte.</p>
But I don't manage to call ft:mark with the correct parameters.
I tried variants of this:
for $i at $p in //entry let $q := $i/q return ft:mark($i $q)
But this gives
Expecting closing bracket for 'ft:mark(…'
I think I have to use concat() in some way, but how?
Thanks in advance
if I got you right you want to evaluate a query, such as
ft:mark(<p>bey welchen die Verbesserungen durch Johann Ballhorn öfter vorkommen als man glauben sollte.</p>[./text() contains text ('Johann' ftand 'Ballhorn') distance at most 5 words ordered][self::*:p or self::*:q])
which you construct from your collection?
<p>bey welchen ...</p> is a database node and <q>[text() contains text ('Johann' ... ]</q> holds a query predicate as string
So you dynamically construct a query string that you like to evaluate?
==
Since ft:mark() operates on database nodes a simply typing
ft:mark(<p>bey welchen die Verbesserungen durch Johann Ballhorn öfter vorkommen als man glauben sollte.</p>[./text() contains text ('Johann' ftand 'Ballhorn') distance at most 5 words ordered][self::*:p or self::*:q])
in BaseXGUi results in
[BXDB0001] ft:mark(element p { ("bey welchen die Verbesserungen durch Johann Ballhorn öfter vorkommen als man glauben sollte.") }[text() contains text ("Johann" ftand "Ballhorn") ordered distance(0-5 word)][(self::*:p or self::*:q)]): database node expected.
==
However, we can create a database from your input data to set up a running example:
db:create('cm', "<collection> <entry> <q>[text() contains text ('Johann' ftand 'Ballhorn') distance at most 5 words ordered][self::*:p or self::*:q]</q> <id>12345</id> <p>bey welchen die Verbesserungen durch Johann Ballhorn öfter vorkommen als man glauben sollte.</p> </entry> </collection>", "cm.xml")
==
Query:
let $in := doc('cm') let $p := $in//p let $q := $in//q return ( $p, $q )
yields
<p>bey welchen die Verbesserungen durch Johann Ballhorn öfter vorkommen als man glauben sollte.</p> <q>[text() contains text ('Johann' ftand 'Ballhorn') distance at most 5 words ordered][self::*:p or self::*:q]</q>
==
let $in := doc('cm') let $p := $in//p let $q := $in//q let $qs := concat('ft:mark($p', $q, ')') return $qs
constructs the query string
ft:mark($p[text() contains text ('Johann' ftand 'Ballhorn') distance at most 5 words ordered][self::*:p or self::*:q])
==
let $in := doc('cm') let $p := $in//p let $q := $in//q let $qs := concat('ft:mark($p', $q, ')') return xquery:eval($qs)
evaluates the query string ... aehh .. tries to evaluate the query string
[XPST0008] Undefined variable $p.
==
http://docs.basex.org/wiki/XQuery_Module#xquery:eval shows how to pass a binding of into the query to be evaluated
let $in := doc('cm') let $p := $in//p let $q := $in//q let $qs := concat('ft:mark($binding', $q, ')') let $bm := map{ '$binding' := $p } return xquery:eval($qs, $bm)
constructs a query string
ft:mark($binding[text() contains text ('Johann' ftand 'Ballhorn') distance at most 5 words ordered][self::*:p or self::*:q]) and a binding of $binding and
results in
<p>bey welchen die Verbesserungen durch <mark>Johann</mark> <mark>Ballhorn</mark> öfter vorkommen als man glauben sollte.</p>
Which, I hope, is the result you wanted to achieve.
All the best, Alex