Skip to content
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

<p><strong>WORKAROUND:</strong><br /> <br /> In order to avoid the limit of the 2000 rows, the workaround is to add a CAML filter to the configuration. </p><div>1.<span class="Apple-tab-span" style="white-space:pre;"> </span>Open ezEdit.</div><div>2.<span class="Apple-tab-span" style="white-space:pre;"> </span>Go to Content | Primary Content Tab. Edit Display Fields, then turn on Advanced Mode.</div><div>3.<span class="Apple-tab-span" style="white-space:pre;"> </span>Find the XML node of the fields that that qlistform querying from, Add the following attribute to this node:</div><div><div><br /> <span style="color: rgb(46, 116, 181);">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;</span><span style="color: rgb(46, 116, 181); text-decoration: underline;"><Fields Name></span><span style="color: rgb(46, 116, 181);">&quot; /&gt;&#xD;&#xA;&lt;/Eq&gt;"</span></div><div><p>Example query for EquipmentId fields:</p></div></div><div><span style="color: rgb(46, 116, 181);">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;"</span></div><div><br /> 4.<span class="Apple-tab-span" style="white-space: pre;"> </span>Save the configuration and check if the issue has been fixed.</div><div><br /> <strong>STATUS:</strong></div><p>Waiting for fix in a future release of QuickApps for SharePoint.</p>

Defect ID

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

Leave a Reply