Hi Erik I update my search option to debug this and the result is as below
Search Options: <search:options xmlns:search="http://marklogic.com/appservices/search";> <search:quality-weight>0</search:quality-weight> <search:search-option>unfiltered</search:search-option> <search:additional-query>{cts:element-query(xs:QName("hmhGuid"), cts:and-query(()))}</search:additional-query> <search:constraint name="name"> <search:range collation="http://marklogic.com/collation//S2"; type="xs:string" facet="false"> <search:facet-option>ascending</search:facet-option> <search:path-index>*:standard_set/@name</search:path-index> </search:range> </search:constraint> <search:constraint name="subject"> <search:range collation="http://marklogic.com/collation//S2"; type="xs:string" facet="true"> <search:facet-option>ascending</search:facet-option> <search:element ns="" name="standard_set"/> <search:attribute ns="" name="subject"/> </search:range> </search:constraint> <search:constraint name="state"> <search:range collation="http://marklogic.com/collation//S2"; type="xs:string" facet="true"> <search:facet-option>ascending</search:facet-option> <search:element ns="" name="standard_set"/> <search:attribute ns="" name="state"/> </search:range> </search:constraint> <search:constraint name="FIPS"> <search:range collation="http://marklogic.com/collation//S2"; type="xs:string" facet="true"> <search:facet-option>ascending</search:facet-option> <search:element ns="" name="standard_set"/> <search:attribute ns="" name="FIPS"/> </search:range> </search:constraint> <search:constraint name="gradefrom"> <search:range collation="http://marklogic.com/collation//S2"; type="xs:string" facet="false"> <search:facet-option>ascending</search:facet-option> <search:element ns="" name="standard"/> <search:attribute ns="" name="gradeFrom"/> </search:range> </search:constraint> <search:constraint name="gradeto"> <search:range collation="http://marklogic.com/collation//S2"; type="xs:string" facet="false"> <search:facet-option>ascending</search:facet-option> <search:element ns="" name="standard"/> <search:attribute ns="" name="gradeTo"/> </search:range> </search:constraint> <search:constraint name="abguid"> <search:range collation="http://marklogic.com/collation//S2"; type="xs:string" facet="false"> <search:facet-option>ascending</search:facet-option> <search:element ns="" name="abguid"/> </search:range> </search:constraint> <search:constraint name="hmhGuid"> <search:range collation="http://marklogic.com/collation//S2"; type="xs:string" facet="false"> <search:facet-option>ascending</search:facet-option> <search:element ns="" name="hmhGuid"/> </search:range> </search:constraint> <constraint name="stem" xmlns="http://marklogic.com/appservices/search";> <word> <term-option>stemmed</term-option> </word> </constraint> <search:transform-results apply="raw" ns="http://marklogic.com/rest-api/transform/AssessmentStandards"; at="/assessment-standards.xqy"> <search:max-matches>2</search:max-matches> <search:max-snippet-chars>150</search:max-snippet-chars> <search:per-match-tokens>20</search:per-match-tokens> </search:transform-results> <search:return-query>false</search:return-query> <search:debug>true</search:debug> </search:options> <search:report id="SEARCH-FLWOR">(cts:search(fn:collection(), cts:query(<cts:and-query xmlns:cts="http://marklogic.com/cts";> <cts:and-query qtextempty="1"/> <cts:and-query> <cts:collection-query> <cts:uri>Standards-Tree</cts:uri> </cts:collection-query> </cts:and-query> </cts:and-query>) , ("unfiltered","faceted"), 0))[1 to 10] </search:report> This clearly shows that my additional query is ignored. Regards, Gnana(GP) This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient(s), please reply to the sender and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email, and/or any action taken in reliance on the contents of this e-mail is strictly prohibited and may be unlawful. Where permitted by applicable law, this e-mail and other e-mail communications sent to and from Cognizant e-mail addresses may be monitored.
_______________________________________________ General mailing list General@developer.marklogic.com Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
