qListView/qChartView only display x amount of records (not caused by SP List View threshold)
qListView/qChartView only display x amount of records (not caused by SP List View threshold)
When using qListView/qChartView only x amount of records are showing. Even when the SharePoint List Threshold is set higher than the amount of items in the list.
<p><span style="color: rgb(68, 68, 68); font-family: 'Trebuchet MS'; font-size: 13px;">By default the <strong>qListView/</strong></span><strong style="color: rgb(68, 68, 68); font-family: 'Trebuchet MS'; font-size: 13px;">qChartView</strong><span style="color: rgb(68, 68, 68); font-family: 'Trebuchet MS'; font-size: 13px;"> will only load the top 2000 rows in SharePoint list.</span></p>
<p style="margin-top:0px;padding-top:0px;vertical-align:top;color:#444444;font-family:'Trebuchet MS';font-size:13px;">To increase the value, the <strong>Max Query Row </strong>value can be adjusted using the <strong>Configuration Editor</strong>.</p><p style="color:#444444;font-family:'Trebuchet MS';font-size:13px;">The default value is empty which is <em>2000</em>. </p><p style="color:#444444;font-family:'Trebuchet MS';font-size:13px;"><img alt="" src="https://prod-support-images-cfm.s3.amazonaws.com/KB_1-D0TJW4_IncreaseQueryRowCount.jpg" /></p><p style="color:#444444;font-family:'Trebuchet MS';font-size:13px;"><strong>NOTE</strong>: For the performance consideration, this is set to 2000 by default. <br /> Please also note that the default value of SharePoint list view threshold for regular accounts is 5000. <br /> So the value of Max Query Row Count should be less than or equal to 5000 unless you also increase the SharePoint list view threshold at the same time.</p>
<p><span style="color: rgb(68, 68, 68); font-family: 'Trebuchet MS'; font-size: 13px;">By default the <strong>qListView/</strong></span><strong style="color: rgb(68, 68, 68); font-family: 'Trebuchet MS'; font-size: 13px;">qChartView</strong><span style="color: rgb(68, 68, 68); font-family: 'Trebuchet MS'; font-size: 13px;"> will only load the top 2000 rows in SharePoint list.</span></p>