I'm having issues with displaying more than 20 records from a Custom Setting on my visualforce page. I've tried using apex:repeat, apex:pageblocktable, apex:datatable with no luck.
Best,
Eric
<apex:page standardController="UserQueueSettings__c" sidebar="false" recordSetVar="UserQueueSettings__c" >
<apex:form >
<apex:pageBlock >
<apex:pageMessages />
<apex:pageBlockButtons >
<apex:commandButton value="Save" action="{!save}"/>
</apex:pageBlockButtons>
<apex:repeat value="{!UserQueueSettings__c}" var="block" rows="1000">
<apex:datatable value="{!block}" var="ES" id="memberTable" rows="1000">
<apex:column headerValue="Name">
<apex:inputField value="{!ES.SetupOwnerId}"/>
<!-- <apex:facet name="header">TEST</apex:facet>
<apex:inputField value="{!ES.Priority_1__c}"
required="false"/>
<apex:outputField value="{!ES.Priority_1__c}" />
-->
</apex:column>
<apex:column headerValue="Priority 1">
<apex:inputField value="{!ES.Priority_1__c}"/>
</apex:column>
<apex:column headerValue="Priority 2">
<apex:inputField value="{!ES.Priority_2__c}"/>
</apex:column>
<apex:column headerValue="Priority 3">
<apex:inputField value="{!ES.Priority_3__c}"/>
</apex:column>
</apex:datatable>
</apex:repeat>
Best Answer
I suspect using the standard controller on a custom setting, or perhaps even the recordSetVar is causing the issue.
My suggestion would be to create a simple visualforce controller and either query for the custom setting record or use the getAll() method, and then iterate over that list in your Visualforce page.
Controller:
And your visualforce would be updated to look like: