Loading...

INTERNAL: qListForm only viewing top 2000 items, when querying the list that have more than 2000 items

Title

INTERNAL: qListForm only viewing top 2000 items, when querying the list that have more than 2000 items

Description

INTERNAL: qListForm only viewing top 2000 items, when querying the list that have more than 2000 items

Please wait...
qListForm only viewing top 2000 items, when querying the list that have more than 2000 items 

Cause

This is the product defect. Defect ID: TFS466185 logged for the issue.

Resolution

WORKAROUND:

In order to avoid the limit of the 2000 rows, the workaround is to add a CAML filter to the configuration. 

1. Open ezEdit.
2. Go to Content | Primary Content Tab. Edit Display Fields, then turn on Advanced Mode.
3. Find the XML node of the fields that that qlistform querying from, Add the following attribute to this node:

CamlFilter="&lt;Eq&gt;&#xD;&#xA;  &lt;FieldRef Name=&quot;ID&quot; /&gt;&#xD;&#xA;  &lt;Value Type=&quot;Counter&quot; Source=&quot;HttpParameter&quot; SourceName=&quot;<Fields Name>&quot; /&gt;&#xD;&#xA;&lt;/Eq&gt;"

Example query for EquipmentId fields:

CamlFilter="&lt;Eq&gt;&#xD;&#xA;  &lt;FieldRef Name=&quot;ID&quot; /&gt;&#xD;&#xA;  &lt;Value Type=&quot;Counter&quot; Source=&quot;HttpParameter&quot; SourceName=&quot;EquipmentId&quot; /&gt;&#xD;&#xA;&lt;/Eq&gt;"

4. Save the configuration and check if the issue has been fixed.

STATUS:

Waiting for fix in a future release of QuickApps for SharePoint.

Defect ID

This is the product defect. Defect ID: TFS466185 logged for the issue.

Leave a Reply