使用 Caml 进行排序

Question

我目前正在尝试按“国家/地区”列进行排序。但是，不断收到错误“需要对象”。我已经这样做了一百万次，但无法让它工作，代码与上次相同，但不起作用。

请帮忙

              <script type="text/javascript">

               $(document).ready(function() {
              var soapEnv =
        "<soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/'> \
        <soapenv:Body> \
                 <GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'> \
                    <listName>db_IMPS_Transaction_Data</listName> \
                    <OrderBy>  
                     <FieldRef Name='COUNTRY' Ascending='False' />
                    </OrderBy>
                        <viewFields> \
                       <ViewFields> \
                        <FieldRef Name='Title'/> \
                       <FieldRef Name='COUNTRY' /> \
                       <FieldRef Name='PMTAMT' /> \
        <FieldRef Name='ITEMS' /> \
        <FieldRef Name='CUSTOMER' /> \
        <FieldRef Name='BRANCH' /> \
        <FieldRef Name='CCY' /> \
        <FieldRef Name='CD' /> \
             <FieldRef Name='A' /> \
        <FieldRef Name='ACH' /> \
        <FieldRef Name='B' /> \
                    </ViewFields> \
                         </viewFields> \
                      </GetListItems> \
                      </soapenv:Body> \
                 </soapenv:Envelope>";

                   $.ajax({

Answer 1

我从来没有通过 JS 调用过这个 Web 服务，但我想你需要将 OrderBy 包装在中。标签：

<query> \
    <Query> \
        <OrderBy>  \
            <FieldRef Name='COUNTRY' Ascending='False' />  \
        </OrderBy>  \
    </Query> \
</query> \