MarkLogic 9+ .NET应用REST API替换XCC：复杂cts查询转XML求助

Perfect, let's tackle converting your cts query to the MarkLogic REST API's XML search request format. I'll start with the full converted XML, then walk through how each piece maps to your original query so you can adapt it for the rest of your 140+ queries.

<search:search xmlns:search="http://marklogic.com/appservices/search">
  <search:query>
    <search:and-query>
      <!-- Target the Records{0} collection -->
      <search:collection-query>
        <search:uri>Records{0}</search:uri>
      </search:collection-query>
      <!-- CreatedOn >= {1} -->
      <search:range-query>
        <search:element ns="" name="CreatedOn"/>
        <search:operator>GE</search:operator>
        <search:value type="dateTime">{1}</search:value>
      </search:range-query>
      <!-- CreatedOn <= {2} -->
      <search:range-query>
        <search:element ns="" name="CreatedOn"/>
        <search:operator>LE</search:operator>
        <search:value type="dateTime">{2}</search:value>
      </search:range-query>
      <!-- /Record/IsLatestVersion = {3} -->
      <search:range-query>
        <search:path>/Record/IsLatestVersion</search:path>
        <search:operator>EQ</search:operator>
        <search:value>{3}</search:value>
      </search:range-query>
      <!-- Insert your additionalQueries here as XML search query nodes -->
      <!-- Example: <search:word-query><search:text>example</search:text></search:word-query> -->
    </search:and-query>
  </search:query>
  <search:options>
    <!-- Return only the Record elements (matches collection('Records{0}')/Record) -->
    <search:return-elements>
      <search:element ns="" name="Record"/>
    </search:return-elements>
    <!-- Wrap results in ArrayOfRecord to match original output structure -->
    <search:wrap>
      <search:start-tag><ArrayOfRecord></search:start-tag>
      <search:end-tag></ArrayOfRecord></search:end-tag>
    </search:wrap>
  </search:options>
</search:search>

Key Mapping Details: #

• Collection Targeting: The <search:collection-query> replaces collection('Records{0}') to restrict the search to your target collection.
• Date Range Filters: The two cts:element-range-query calls translate directly to <search:range-query> nodes, using GE (greater than or equal) and LE (less than or equal) operators, with explicit dateTime type for the values.
• Path Range Filter: The cts:path-range-query maps to a <search:range-query> using the <search:path> node instead of <search:element>, keeping the exact path from your original query.
• Additional Queries: Just append any extra query conditions (like word queries, value queries, etc.) as valid MarkLogic search XML nodes inside the <search:and-query> block.
• Result Formatting: The <search:return-elements> ensures only <Record> elements are returned, and <search:wrap> adds the <ArrayOfRecord> wrapper to match your original output structure.

内容的提问来源于stack exchange，提问作者Vergil C.