One thing I discovered is that if I change "search-option" to "unfiltered", @total and the number of search results are both 88.
Regards, Danny On Tue, Jan 6, 2015 at 9:14 AM, Danny Sinang <d.sin...@gmail.com> wrote: > Hi Erik, > > Here's the query and the options : > > xquery version "1.0-ml"; > > > import module namespace search = "http://marklogic.com/appservices/search"; > at "/MarkLogic/appservices/search/search.xqy"; > > declare option xdmp:mapping "false"; > > declare variable $options := > <options xmlns="http://marklogic.com/appservices/search";> > <search-option>filtered</search-option> > <debug>false</debug> > <term> > <empty apply="all-results"/> > <term-option>wildcarded</term-option> > <term-option>case-insensitive</term-option> > <term-option>punctuation-sensitive</term-option> > <term-option>diacritic-sensitive</term-option> > </term> > <grammar> > <starter strength="30" apply="grouping" delimiter=")">(</starter> > <starter strength="40" apply="prefix" > element="cts:not-query">-</starter> > <joiner strength="10" apply="infix" element="cts:or-query" > tokenize="word">OR</joiner> > <joiner strength="20" apply="infix" element="cts:and-query" > tokenize="word">AND</joiner> > <joiner strength="20" apply="element-joiner" ns=" > http://www.nejm.org/custom-field-query"; at="/lib/custom-fields.xqy" > element="cts:element-query" tokenize="word">CHILD</joiner> > <joiner strength="50" apply="constraint" compare="LT" > tokenize="word">LT</joiner> > <joiner strength="50" apply="constraint" compare="LE" > tokenize="word">LE</joiner> > <joiner strength="50" apply="constraint" compare="GT" > tokenize="word">GT</joiner> > <joiner strength="50" apply="constraint" compare="GE" > tokenize="word">GE</joiner> > <joiner strength="50" apply="constraint" compare="NE" > tokenize="word">NE</joiner> > <quotation>"</quotation> > <joiner strength="50" apply="constraint">:</joiner> > </grammar> > <!-- > <searchable-expression>/questionAsset</searchable-expression> > --> > <constraint name="qbankId"> > <value> > <element ns="" name="qBankId"/> > </value> > </constraint> > <constraint name="key"> > <value> > <element ns="" name="key"/> > </value> > </constraint> > <constraint name="qId"> > <value> > <element ns="" name="qId"/> > </value> > </constraint> > <constraint name="productId"> > <value> > <element ns="" name="productId"/> > </value> > </constraint> > <constraint name="qAuthoringState"> > <value> > <element ns="" name="qAuthoringState"/> > </value> > </constraint> > <constraint name="qBankMembershipState"> > <value> > <element ns="" name="qBankMembershipState"/> > </value> > </constraint> > <constraint name="qApName"> > <value> > <element ns="" name="qApName"/> > </value> > </constraint> > <constraint name="accreditationTypeState"> > <value> > <element ns="" name="accreditationTypeState"/> > </value> > </constraint> > <constraint name="questionSetName"> > <value> > <element ns="" name="questionSetName"/> > </value> > </constraint> > <constraint name="qComments"> > <custom facet="false"> > <parse apply="qComments" ns="http://www.nejm.org/custom-field-query"; > at="/lib/custom-fields.xqy"/> > </custom> > </constraint> > <constraint name="qSupplementGroup"> > <custom facet="false"> > <parse apply="qSupplementGroup" ns=" > http://www.nejm.org/custom-field-query"; at="/lib/custom-fields.xqy"/> > </custom> > </constraint> > <constraint name="qQuestionOfTheWeek"> > <custom facet="false"> > <parse apply="qQuestionOfTheWeek" ns=" > http://www.nejm.org/custom-field-query"; at="/lib/custom-fields.xqy"/> > </custom> > </constraint> > <constraint name="qFITB"> > <custom facet="false"> > <parse apply="qFITB" ns="http://www.nejm.org/custom-field-query"; > at="/lib/custom-fields.xqy"/> > </custom> > </constraint> > <constraint name="qApDifferentiation"> > <range type="xs:double"> > <element ns="" name="qApDifferentiation"/> > </range> > </constraint> > <constraint name="qApDiscrimination"> > <range type="xs:double"> > <element ns="" name="qApDiscrimination"/> > </range> > </constraint> > <constraint name="qApRelevance"> > <range type="xs:double"> > <element ns="" name="qApRelevance"/> > </range> > </constraint> > <constraint name="qCreatedDate"> > <range type="xs:dateTime"> > <element ns="" name="qCreatedDate"/> > </range> > </constraint> > <constraint name="qLastModifiedDate"> > <range type="xs:dateTime"> > <element ns="" name="qLastModifiedDate"/> > </range> > </constraint> > <constraint name="qAudiencePoolGroup"> > <element-query ns="" name="qAudiencePoolGroup"/> > </constraint> > <constraint name="qBankGroup"> > <element-query ns="" name="qBankGroup"/> > </constraint> > <constraint name="qBankDimensions"> > <element-query ns="" name="qBankDimensions"/> > </constraint> > <constraint name="dimensionFacts"> > <element-query ns="" name="dimensionFacts"/> > </constraint> > <constraint name="childDimension"> > <element-query ns="" name="childDimension"/> > </constraint> > <constraint name="name"> > <value> > <element ns="" name="name"/> > </value> > </constraint> > <constraint name="dimension"> > <custom facet="false"> > <parse apply="dimension" ns="http://www.nejm.org/custom-field-query"; > at="/lib/custom-fields.xqy"/> > </custom> > </constraint> > <constraint name="entry"> > <element-query ns="" name="entry"/> > </constraint> > <constraint name="value"> > <element-query ns="" name="value"/> > </constraint> > <constraint name="subSpecialty"> > <custom facet="false"> > <parse apply="subSpecialty" ns=" > http://www.nejm.org/custom-field-query"; at="/lib/custom-fields.xqy"/> > </custom> > </constraint> > <return-query>true</return-query> > <return-facets>false</return-facets> > <return-metrics>false</return-metrics> > <additional-query> > <cts:collection-query xmlns:cts="http://marklogic.com/cts";> > <cts:uri>question</cts:uri> > </cts:collection-query> > </additional-query> > <operator name="sort"> > <state name="requestparam"> > <sort-order direction="ascending" type="xs:int"> > <element ns="" name="qId"/> > </sort-order> > <sort-order> > <score/> > </sort-order> > </state> > </operator> > </options>; > > let $search := '(qAuthoringState:"Approved" OR qAuthoringState:"Warning") > AND (qAudiencePoolGroup:(qApName:"Internal Medicine Audience Pool" AND > qApRelevance GE "1" AND qApRelevance LE "1")) AND (entry:(key:1 AND > value:(qBankDimensions:(name:"Sub-Specialty" AND > dimensionFacts:(name:"Cardiology"))))) AND sort:requestparam' > return > search:search($search, $options, 1, 100) > > > On Mon, Jan 5, 2015 at 9:45 PM, Erik Hennum <erik.hen...@marklogic.com> > wrote: > >> Hi, Danny: >> >> Can you share your query and options? >> >> >> Erik Hennum >> >> ------------------------------ >> *From:* general-boun...@developer.marklogic.com [ >> general-boun...@developer.marklogic.com] on behalf of Danny Sinang [ >> d.sin...@gmail.com] >> *Sent:* Monday, January 05, 2015 1:44 PM >> *To:* general >> *Subject:* [MarkLogic Dev General] Search API total not equal to number >> of search results >> >> After running this filtered query : >> >> *search:search($search, $options, 1, 100)* >> >> >> I got */search:response/@total* = 88 despite there being only 36 search >> results returned by the query. >> >> The content source / database being queried does not have a fragment >> root or parent. >> >> What could I be doing wrong ? >> >> Regards, >> Danny >> >> >> >> >> _______________________________________________ >> General mailing list >> General@developer.marklogic.com >> http://developer.marklogic.com/mailman/listinfo/general >> >> >
_______________________________________________ General mailing list General@developer.marklogic.com http://developer.marklogic.com/mailman/listinfo/general
