Caml查询或条件-列表中超过5000个项目 [英] Caml query- or condition - for more than 5000 items in list

问题描述

你好

我正在尝试添加CAML-或在javascript文件中查询列表的两列，该列有5000多个项目.

I am trying to add CAML - OR query in javascript file for two columns of list, which have more than 5000 items.

未提供任何结果，并引发错误:  500(内部服务器错误)

Its not providing any result, throwing an error : 500(Internal Server Error)

查询:

<Query><Where><Or><Contains><FieldRef Name='Name1' /><Value Type='Text'>" + request.term + "</Value></Contains><Contains><FieldRef Name='CustomerNumber'/><Value Type='Text'>" + request.term + "</Value></Contains></Or><And><Eq><FieldRef Name='Blocked'/><Value Type='Boolean'>No</Value></Eq></And></Where></Query> 

需要搜索未屏蔽的客户名称或客户编号.

need to search for customer name or customer number, which is not blocked.

对此有任何建议.

谢谢.

此致

Jayashri

推荐答案

根据某些过滤条件为列表创建视图，并在CAML查询中使用行限制"选项.

Create views for your list based on some filter condition and use Row limit option in your CAML Query.. 

示例:

<RowLimit>50</RowLimit>

这篇关于Caml查询或条件-列表中超过5000个项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！