function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Jackson DiasJackson Dias 

pagination in vf

what is pagination in vf ? how do I implement it with an example. Thanks
SandhyaSandhya (Salesforce Developers) 
Hi Jackson Dias,
Usually, Salesforce shows by default 25 records at a time when you want to display 10records at a time we need to make use of Previous, next and last buttons in the Visual force page this itself is pagination.

Please refer below example how we can achieve this.
  
<apex:page standardController="Account" <b>recordSetvar="accounts"</b>>
<apex:pageBlock title="ViewingAccounts">
<apex:form id="theForm">
<apex:pageBlockSection>
<apex:dataList var="a" value="{!accounts}" type="1">
{!a.name}
</apex:dataList>
</apex:pageBlockSection>
<apex:panelGrid columns="2">
<apex:commandLink action="<b>{!previous}</b>">Previous</apex:commandlink>
<apex:commandLink action="<b>{!next}</b>">Next</apex:commandlink>
</apex:panelGrid>
</apex:form>
</apex:pageBlock>
</apex:page>
  
public class tenPageSizeExt {
public tenPageSizeExt(ApexPages.StandardSetControllercontroller){
controller.setPageSize(10);
}
}
Also, refer below link for one more example

http://sfdcsrini.blogspot.com/2014/07/simple-visualforce-pagination-example.html .

Hope this helps you!

Please accept my solution as Best Answer if my reply was helpful. It will make it available for other as the proper solution. If you felt I went above and beyond, you can give me kudos.
 
Thanks and Regards
Sandhya

 
Rupal KumarRupal Kumar
Hi,
As the number of records increases on the vf page Select value of number of record like you want to display only 10,20,30 and 40... record on vf page with Next  and Privous button its pagination.

Example-

Vf page- 
<apex:page controller="Pagination_minnew">
    <apex:form >
        <apex:pageBlock id="pb">
            <apex:pageBlockTable value="{!Accounts}" var="a">
              <apex:column >
                    <apex:facet name="header">Action</apex:facet>
                    <apex:inputCheckbox />
                </apex:column>
                <apex:column value="{!a.Name}"/>
                <apex:column value="{!a.Type}"/>
                <apex:column value="{!a.BillingCity}"/>
                <apex:column value="{!a.BillingState}"/>
                <apex:column value="{!a.BillingCountry}"/>
            </apex:pageBlockTable>
            <apex:panelGrid columns="7">
                <apex:commandButton status="fetchStatus" reRender="pb" value="|<" action="{!setCon.first}" disabled="{!!setCon.hasPrevious}" title="First Page"/>
                <apex:commandButton status="fetchStatus" reRender="pb" value="Next" action="{!setCon.previous}" disabled="{!!setCon.hasPrevious}" title="Previous Page"/>
                <apex:commandButton status="fetchStatus" reRender="pb" value=">" action="{!setCon.next}" disabled="{!!setCon.hasNext}" title="Next Page"/>
                <apex:commandButton status="fetchStatus" reRender="pb" value=">|" action="{!setCon.last}" disabled="{!!setCon.hasNext}" title="Last Page"/>
                <apex:outputText >{!(setCon.pageNumber * size)+1-size}-{!IF((setCon.pageNumber * size)>noOfRecords, noOfRecords,(setCon.pageNumber * size))} of {!noOfRecords}</apex:outputText>
                <apex:commandButton status="fetchStatus" reRender="pb" value="Refresh" action="{!refresh}" title="Refresh Page"/>
                <apex:actionFunction name="show" action="{!refresh}" reRender="pb" />
                <apex:selectList value="{!size}"  multiselect="false" size="1" onchange="show()">
                      <apex:selectOptions value="{!items}"/>
                   </apex:selectList>      
                <apex:outputPanel style="color:#4AA02C;font-weight:bold">
                    <apex:actionStatus id="fetchStatus" startText="Fetching..." stopText=""/>
                </apex:outputPanel>
            </apex:panelGrid>
        </apex:pageBlock>
    </apex:form>
</apex:page>

Controller- 
public with sharing class Pagination_minnew {
    Public Integer noOfRecords{get; set;}
    Public Integer size{get;set;}
    public boolean test = false;
    public ApexPages.StandardSetController setCon {
        get{
            if(setCon == null){
                if(test == false){
                size = 10;
                }
                string queryString = 'Select Name, Type, BillingCity, BillingState, BillingCountry from Account order by Createddate DESC';
                setCon = new ApexPages.StandardSetController(Database.getQueryLocator(queryString));
                setCon.setPageSize(size);
                noOfRecords = setCon.getResultSize();
                test = true;
            }
            return setCon;
        }set;
    }
     
    Public List<Account> getAccounts(){
        List<Account> accList = new List<Account>();
        for(Account a : (List<Account>)setCon.getRecords())
            accList.add(a);
        return accList;
    }
     
    public pageReference refresh() {
        setCon = null;
        getAccounts();
        setCon.setPageNumber(1);
        return null;
    }
    public List<SelectOption> getItems() {
            List<SelectOption> options = new List<SelectOption>();
            options.add(new SelectOption('10','10'));
            options.add(new SelectOption('20','20'));
            options.add(new SelectOption('30','30'));
              options.add(new SelectOption('40','40'));
            return options;
        }
}

Thanks
Rupal Kumar
http://mirketa.com
Deepali KulshresthaDeepali Kulshrestha
Hi Jackson,

Pagination is the process of displaying a large number of records and displaying the records on multiple pages within in Salesforce
  
<apex:page standardController="Opportunity" extensions="oppoNe" recordSetVar="opportunities">
<apex:pageBlock title="Viewing Opportunities">
<apex:form id="theForm">
<apex:pageBlockSection >
<apex:dataList var="opp" value="{!opportunities}">
{!opp.Name}
</apex:dataList>
</apex:pageBlockSection>
<apex:panelGrid columns="4">
<apex:commandLink action="{!first}">FIRST</apex:commandLink>
<apex:commandLink action="{!next}">NEXT</apex:commandLink>
<apex:commandLink action="{!previous}">PREVIOUS</apex:commandLink>
<apex:commandLink action="{!last}">LAST</apex:commandLink>
</apex:panelGrid>
 
</apex:form>
</apex:pageBlock>
</apex:page>

Controller:

public class oppoNe {
 
    public oppoNe(ApexPages.StandardSetController controller) {
        controller.setPageSize(10);
    }
 
}
I suggest you visit this link, it will help you 

https://mytutorialrack.com/how-to-implement-pagination-in-visualforce-with-example/
http://amitsalesforce.blogspot.com/2015/04/pagination-using-standardsetcontroller.html


I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.

Thanks and Regards,

Deepali Kulshrestha.

 
Suraj Tripathi 47Suraj Tripathi 47
Hi Jackson Dias,
You can take reference from below code for the pagination.
//Vf Page 
<apex:page controller="Pagination" sidebar="false" showHeader="false">
    <apex:form >
        <apex:pageBlock id="details">
            <apex:pageblockTable value="{!acclist}" var="con">
                <apex:column value="{!con.FirstName}"/>
                <apex:column value="{!con.LastName}"/>
                <apex:column value="{!con.Email}"/>
                <apex:column value="{!con.Phone}"/>
            </apex:pageblockTable>
            <apex:pageblockButtons >
                <apex:commandButton action="{!FirstPage}" value="Page" />
                <apex:commandButton value="Previous" rerender="details" action="{!previous}" disabled="{!prev}"/>
                <apex:commandButton value="Next" rerender="details" action="{!next}" disabled="{!nxt}"/>
            </apex:pageblockButtons>
        </apex:pageBlock>
    </apex:form>
</apex:page>

//Class 
public class Pagination
{
    List<Contact> contactList=[SELECT FirstName,LastName,Email,Phone FROM Contact LIMIT 10000];
    private integer totalRecs = contactList.size();
    public integer OffsetSize = 0;
    private integer LimitSize= 10;

    public List<Contact> getacclist()
    {
        List<Contact> con = Database.Query('SELECT FirstName, LastName, Email, Phone FROM Contact LIMIT :LimitSize OFFSET :OffsetSize');
        System.debug('Values are' + con);
        return con;
    }
    public void FirstPage()
    {
        OffsetSize = 0;
    }
    public void previous()
    {
        OffsetSize = OffsetSize - LimitSize;
    }public void next()
    {
        OffsetSize = OffsetSize + LimitSize;
    }public void LastPage()
    {
        OffsetSize = totalrecs - math.mod(totalRecs,LimitSize);
    }
    public boolean getprev()
    {
        if(OffsetSize == 0)
            return true;
        else
            return false;
    }
    public boolean getnxt()
    {
        if((OffsetSize + LimitSize) > totalRecs)
            return true;
        else
            return false;
    }
   
}


If you find your Solution then mark this as the best answer.

Thank you!

Regards,
Suraj Tripathi