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. <?xml version="1.0" encoding="utf-8"?> <books> <book Id='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> <book Id='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> <book Id='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 -<http://localhost:8004/eval.xqy?iefix.txt##> <<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 -<http://localhost:8004/eval.xqy?iefix.txt##> <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<http://in.rd.yahoo.com/tagline_yyi_1/*http:/in.yahoo.com/>.
_______________________________________________ General mailing list [email protected] http://xqzone.com/mailman/listinfo/general
