Hi,
Structure of the document :
<books>
<chapters>
<chapter><title1>fuji</title1><title2></title2></data></chapter>
<chapter><title1>icecream</title1><title2></title2></data></chapter>
<chapter><title1>fuji cream</title1><title2></title2></data></chapter>
</chapters>
</books>
I am doing a cts:search on chapter element like
cts:search(/books/chapters/chapter, cts:element-word-query(xs:QName("title"),
'fuji',"case-insensitive"),'unfiltered')
I get all the chapter element result as :
<chapter><title1>fuji</title1><title2></title2></data></chapter>
<chapter><title1>icecream</title1><title2></title2></data></chapter>
<chapter><title1>fuji cream</title1><title2></title2></data></chapter>
As it matches the chapter element and return all the chapter elements from same
doc.
I only want to restrict my results to
<chapter><title1>fuji</title1><title2></title2></data></chapter>
<chapter><title1>fuji cream</title1><title2></title2></data></chapter>
For that I tried doing :
for $searchResult in cts:search(/books/chapters/chapter,
cts:element-word-query(xs:QName("title"),
'fuji',"case-insensitive"),'unfiltered')
return
if (fn:contains($searchResult//title1//text(),
'fuji') eq fn:true())then $searchResult else ()
This is hitting performance.
Please let me know, what can I achieve this without impacting performance
Thanks
Pragya
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further, you are
not
to copy, disclose, or distribute this e-mail or its contents to any other
person and
any such actions are unlawful. This e-mail may contain viruses. Infosys has
taken
every reasonable precaution to minimize this risk, but is not liable for any
damage
you may sustain as a result of any virus in this e-mail. You should carry out
your
own virus checks before opening the e-mail or attachment. Infosys reserves the
right to monitor and review the content of all messages sent to or from this
e-mail
address. Messages sent to or from this e-mail address may be stored on the
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
_______________________________________________
General mailing list
[email protected]
http://developer.marklogic.com/mailman/listinfo/general
