Hi Chad,
One more sample code
let $qtext := "Biology"
return
cts:search(//subj-group,
cts:and-query((
cts:collection-query("content"),
cts:element-attribute-value-query(xs:QName("subj-group"), xs:QName("subj-group-type"), "heading"),
cts:element-word-query(xs:QName("subject"), $qtext)
)))
Regards,
Asit Nautiyal
From: Asitmohan Nautiyal
Sent: Friday, May 08, 2015 9:58 AM
To: MarkLogic Developer Discussion
Subject: RE: [MarkLogic Dev General] Searching elements
Hi Chad,
Please find the below sample code and I hope this will work for you sure :)
let $qtext := "Biology"
return
cts:search(fn:collection("content")//subj-group,cts:and-query((
cts:element-attribute-value-query(xs:QName("subj-group"), xs:QName("subj-group-type"), "heading"), cts:element-word-query(xs:QName("subject"), $qtext)
)))
Regards,
Asit Nautiyal
Hello,
I have a follow up question, regarding searching a specific element.
The suggestions provided were very helpful, but they don’t search for a specific element within a path (as far as I can tell).
I’m getting results, but the problem is we have multiple elements with the name of “subject”. So the search is returning results for all elements named “subject”,
rather than the specific “subject” element I’m looking for.
For example:
<subj-group subj-group-type="other">
<subject>Cell biology & molecular genetics</subject>
<subject>Crop genetics</subject>
<subject>Plant genetic resources</subject>
<subject>Production agriculture</subject>
<subject>Crop quality</subject>
</subj-group>
<subj-group subj-group-type="heading">
<subject>Beyond the Yield Curves: Exerting the Power of Genetics, Genomics, and Synthetic Biology</subject>
</subj-group>
I’d really only like to search and return results for the green element above.
I’m using the following query now and it’s searching all <subject> elements and returning them:
let $qtext := "Crop"
let $q := cts:and-query((cts:collection-query("content"), cts:element-attribute-value-query(xs:QName("subj-group"), xs:QName("subj-group-type"), "heading"),
cts:element-word-query(xs:QName("subject"), $qtext)))
return cts:element-values(xs:QName("subject"), (), (), $q)
How can I restrict it to a specific path/element?
Thanks much!
-Chad
From: [email protected] [mailto:[email protected]]
On Behalf Of Chad Bishop
Sent: Wednesday, May 06, 2015 9:09 AM
To: MarkLogic Developer Discussion
Subject: Re: [MarkLogic Dev General] Searching elements
Thank you all for your responses and help.
I’ll give those a try.
Thanks again,
-Chad
From:
[email protected] [mailto:[email protected]]
On Behalf Of Indrajeet Verma
Sent: Wednesday, May 06, 2015 12:49 AM
To: MarkLogic Developer Discussion
Subject: Re: [MarkLogic Dev General] Searching elements
Hi Chad Bishop,
|
You can try using cts:element-values() as well to get distinct subject values based on your input,
|
let $qtext := "whatever search"
|
let $terms := fn:tokenize($qtext," ")
|
let $q := cts:and-query((
|
cts:collection-query("content"),
|
cts:element-attribute-value-query(xs:QName("subj-group"), xs:QName("subj-group-type"),"heading"),
|
cts:element-word-query(xs:QName("subject"), $terms)
|
))
|
return cts:element-values(xs:QName("subject"), (), (), $q)
If you want exact subject values, use cts:element-value-query and case-insensitive option OR cts:element-range-query
Note - You would need to create range index for the subject to run above code.
![Inline image 1]()
Regards,
Indy
|
On Wed, May 6, 2015 at 9:17 AM, Asitmohan Nautiyal <[email protected]> wrote:
Hi Chad,
Avoid use fn:distinct-values() function as its again a expensive in terms of performance. Use cts:values() function to get distinct terms from a specified element.
Refer https://docs.marklogic.com/cts:values
cts:collection-query("content"),
cts:element-attribute-value-query(xs:QName("subj-group"), xs:QName("subj-group-type"),xs:string(heading)))))
Note : Create path range index for subject element in your database.
Greetings,
I’m wondering if someone can help with the best way to approach searching a specific element and returning the matching values of that element.
I figured xpath would be best so set this up:
let $term1 := "what"
let $term2 := "ever"
let $subjects := fn:collection("content")/article/front/article-meta/article-categories/subj-group[@subj-group-type = "heading"]/subject[fn:contains(., $term1) and fn:contains(., $term2)]
for $subject in fn:distinct-values($subjects)
return $subject
However, the number of terms will be variable, so I created this:
let $qtext := "whatever search"
let $terms := fn:tokenize($qtext," ")
let $contains := for $term in $terms
return
if ($term != $terms[fn:last()])
then fn:concat("fn:contains(., ", """", $term, """", ") and ")
else fn:concat("fn:contains(., ", """", $term, """", ")")
let $containsText := fn:string-join($contains)
let $subjects := fn:collection("content")/article/front/article-meta/article-categories/subj-group[@subj-group-type = "heading"]/subject[$containsText]
for $subject in fn:distinct-values($subjects)
return $subject
The problem is the $containsText isn’t evaluated as a function(s).
Is there a way to do that or should I be using something different?
Any help or advice is much appreciated,
-Chad
~~~~~~~~~~~
Chad Bishop
Lead Developer
Science Societies
Synergy in Science: Partnering for Solutions
2015
ASA, CSSA, and SSSA International Annual Meeting
with the Entomological Society of America
November 15-18 | Minneapolis, Minnesota
www.acsmeetings.org
::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.
----------------------------------------------------------------------------------------------------------------------------------------------------
_______________________________________________
General mailing list
[email protected]
Manage your subscription at:
http://developer.marklogic.com/mailman/listinfo/general
|
