Hi Danny ,
Its working fine :)
I have added only Fragment root for <book> tag. Now I am getting correct facet
results.
But havn't used the searchable-expression /books/book in search query.
Thank you very much :)
Regards,
Mano
________________________________
From: Danny Sokolsky <[email protected]>
To: General Mark Logic Developer Discussion <[email protected]>
Sent: Tue, 16 February, 2010 11:37:37 PM
Subject: RE: [MarkLogic Dev General] Using Facet with different node in single
file
Hi Mano,
If your XML is really organized like the sample you gave, you can try
fragmenting on book and making your searchable-expression /books/book.
-Danny
From:[email protected]
[mailto:[email protected]] On Behalf Of mano m
Sent: Tuesday, February 16, 2010 5:55 AM
To: [email protected]
Subject: [MarkLogic Dev General] Using Facet with different node in single file
Hi ,
My xml document contains information about books (Id, author, Pubdate, Title
and Abstract). I would like to search the document with facet on Publish date.
I have used range constraint with Buckets of year range.. When user search for
the author (say “Surjit”) the expected result should be one Facet i.e. 1980s
and count should 1.
Since there are multiple books (node) in single xml, facet is not working
properly.
Please find the xml document and XQuery as follows.
<?xmlversion="1..0"encoding="utf-8"?>
<books>
<bookId='1'>
<author>Surjit Singh Barnala</author>
<pubDate>1983</pubDate>
<Title>My other two daughters’</Title>
<Abstract>
An eminent politician writes a simple but engrossing novel
that has nothing to do with politics
but about two women whom he loved as daughters</Abstract>
</book>
<bookId='2'>
<author>SIVA PRASAD DANTU</author>
<pubDate>1995 </pubDate>
<Title>TWO WORDS THAT BRING TRUE HAPPINESS</Title>
<Abstract>TWO WORDS THAT BRING THE REAL HAPPYNESS TO YOU You know
these words that bring the true happiness to you.But at the same time you...
</Abstract>
</book>
<bookId='3'>
<author>Charles Dickens </author>
<pubDate>2000 </pubDate>
<Title>Tale of Two Cities </Title>
<Abstract>Tale of Two Cities by Charles Dickens The theme of Tale
of Two Cities is that ill-treatment will eventually be repaid by
ill-treatment——not...</Abstract>
</book>
</books>
xQuery
xquery version "1.0-ml";
import module namespace search = "http://marklogic.com/appservices/search"; at
"/MarkLogic/appservices/search/search.xqy";
let $options := <options xmlns="http://marklogic.com/appservices/search";>
<return-results>true</return-results>
<return-facets>true</return-facets>
<constraint name="facet-on-PubDate">
<range type="xs:gYear" >
<facet-option>limit=10</facet-option>
<element ns="" name="pubDate"/>
<bucket ge="1980" lt="1991" name="1980s">1980s</bucket>
<bucket ge="1991" lt="2001" name="1990s">1990s</bucket>
<bucket ge="2001" lt="2011" name="2000s">2000s</bucket>
</range>
</constraint>
</options>
let $ds:= search:search("Surjit", $options)
return $ds
Search Result
- <<search: facet name="facet-on-PubDate">
<<search: facet-value name="1980s"count="1">1980s</search: facet-value>
<<search: facet-value name="1990s"count="1">1990s</search: facet-value>
<<search: facet-value name="2000s"count="1">2000s</search: facet-value>
</search: facet>
The query text “Surjit” exists only in Book (id 1) (i.e Pub Date is 1980),
since the xml document contains multiple books we are getting the all facets
with count as 1. But expected result is
- <search: facet name="facet-on-PubDate">
<<search: facet-value name="1980s"count="1">1980s</search: facet-value>
</search: facet>
Above query is working fine if I have separate xml for each book.
Regards,
Mano
________________________________
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!
http://downloads.yahoo.com/in/internetexplorer/_______________________________________________
General mailing list
[email protected]
http://xqzone.com/mailman/listinfo/general
