-
How to implement the pagination in Salesforce Object Query Language (SOQL)?
How to implement the pagination in Salesforce Object Query Language (SOQL)?
-
2 Replies
-
In spring 12, Salesforce has come up with ability of SOQL to get records from position “X” instead of position “1” every time to help creating pagination feature.
Select Id, Name from Lead LIMIT 5 OFFSET 2
Above query will return 5 Lead records starting from record number 10 (5×2). - [adinserter block='9']
-
Hi
Yes you can implement pagination in Visualforce as follows:
<apex:pageblockSection >
<apex:outputPanel id=”myPanel”>
<apex:PageBlockTable var=”c1″ value=”{!cnd}”>
<apex:column headerValue=”First Name”>
<apex:inputField value=”{!c1.First_Name__c}”/>
</apex:column>
<apex:column headerValue=”Last Name”>
<apex:inputField value=”{!c1.Last_Name__c}”/>
</apex:column>
<apex:column headerValue=”City”>
<apex:inputField value=”{!c1.City__c}”/>
</apex:column>
<apex:facet name=”footer”>Showing Page # {!pageNumber} of {!totalPages}</apex:facet>
</apex:PageBlockTable>
</apex:outputPanel>
</apex:pageblockSection>Thanks
Log In to reply.
