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 <[email protected]> wrote: > Hi, Danny: > > Can you share your query and options? > > > Erik Hennum > > ------------------------------ > *From:* [email protected] [ > [email protected]] on behalf of Danny Sinang [ > [email protected]] > *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 > [email protected] > http://developer.marklogic.com/mailman/listinfo/general > >
_______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
