CAML查询orderby收到日期不起作用 [英] CAML query orderby Received Date is not working

问题描述

The below CAML query to sort list of items based on 'Received Date' in descending order is not working properly and the results are displayed in random order.

camlQuery.set_viewXml('
  <View>
    <Query>
      <OrderBy>
        <FieldRef Name=\'SubmittalReceivedDate\' Ascending=\'FALSE\'/>
      </OrderBy>
      <Where>
        <Eq>
          <FieldRef Name=\'ProjectNumber\'/>
          <Value Type=\'Text\'>' + projectNumber + '</Value>
        </Eq>
      </Where>
    </Query>
  </View>
');

请让我知道该错误以及如何进行修改以使其正常工作.

Please let me know the error and how to modify to make it work.

我们将为您提供任何帮助.

Any help is appreciated. Thanks in advance.

>

推荐答案

我希望您再次检查了字段名称，并确保它是日期字段而不是文本字段.

I hope you have double checked the field name and also that its a date field and not a text field. 

这篇关于CAML查询orderby收到日期不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！