Pagination Concept in Salesforce

-
This post describe How to implement concept of Pagination with custom controller.

During the Pagination of your records you have to take care of these two things
First is "How many records/rows you are going to display on the page" and 

second one is 

"On what condition First,Last,Pre and  Next button will be clickable "

Here you can find the logic of both.

 VF Page

 <apex:page controller="PaginitionMthd">
    <apex:form >
        <apex:pageBlock title="Accounts">
            <apex:pageBlockTable value="{!accList}" var="a" id="fresh">
                <apex:column headerValue="Name">
                    <apex:outputText value="{!a.name}"/>
                </apex:column>             
                <apex:column headerValue="Industry">
                    <apex:outputText value="{!a.industry}"/>
                </apex:column>                
            </apex:pageBlockTable>
            
            <apex:pageBlockButtons location="bottom">
                <apex:outputPanel id="btnPanel">
                    <apex:commandButton action="{!firstPage}" value="FirstPage" reRender="fresh,pan,btnPanel" disabled="{!If((index > 0),false,true)}"  />
                    <apex:commandButton action="{!previous}" value="Previous" reRender="fresh,pan,btnPanel" disabled="{!If((index > 0),false,true)}"/>&nbsp;
                    <apex:commandButton action="{!next}" value="Next" reRender="fresh,pan,btnPanel" disabled="{!If((index+blocksize < totalRecs),false,true)}"/>
                    <apex:commandButton action="{!lastPage}" value="LastPage" reRender="fresh,pan,btnPanel" disabled="{!If((index+blocksize < totalRecs),false,true)}" />
            </apex:outputPanel>
                </apex:pageBlockButtons>
        </apex:pageBlock>
        <apex:outputPanel id="pan">
        Page Number : {!showingNum} of {!totalPage}
        </apex:outputPanel>
       
    </apex:form>

</apex:page>

Class

 public class PaginitionMthd 
{    
    public List<Account> accList {get;set;}
    public integer totalRecs {get;set;}  
    public integer index {get;set;}
    public integer blockSize {get;set;}
   
    
    public PaginitionMthd() 
    {
        totalRecs = [select count() from account];
        index = 0;
        blockSize = 8;
        system.debug('Total records are : '+totalRecs);
        accList = [select id,name,industry from account limit : blocksize OFFSET : index];
       
        
    }
    public void firstPage()
    {
        index = 0;
        system.debug('on First click :'+index);
        accList = [select id,name,industry from account limit : blocksize OFFSET : index];
       
    }
    public void previous()
    {
        index = index-blocksize;
        system.debug('on Previous btn click :'+index);
        accList = [select id,name,industry from account limit : blocksize OFFSET : index];
        
    }
    
    public void next()
    {
        index = index+blocksize;
        system.debug('on Next btn click :'+index);
        accList = [select id,name,industry from account limit : blocksize OFFSET : index];
        
    }
    public void lastPage()
    {
        index = totalRecs-Math.mod(totalRecs,blocksize);
        system.debug('on Last btn click :'+index);
        accList = [select id,name,industry from account limit : blocksize OFFSET : index];
    }
    
    public Integer getShowingNum(){
        return index/blocksize + 1;
    }
    public Integer getTotalPage(){
        return totalRecs/blocksize + 1;
    }

}

Comments

Post a Comment

Popular posts from this blog

Dynamically Add/Delete rows in Visualforce Page

-
Image
Here is a simple example of adding or deleting rows dynamically in a VF page using the concept of Wrapper Class. Controller-- public with sharing class AddNewRows {     public List<ContactWrapper> cwrap {get;set;}     public Contact con {get;set;}     public Integer rowIndex {get;set;}          public AddNewRows(ApexPages.StandardController controller)     {         rowIndex = 0;         cwrap = new List<ContactWrapper>();         con = new Contact();         cwrap.add(new ContactWrapper(con,0));  //call ContactWrapper class //constructor     }          public void addRows()     {         rowIndex += 1;         Contact c = new Contact(); // create new instance of object         cwrap.add(new Contact...
Read more

Process Automation Specialist Superbadge

-
Hi Folks, This superbadge is all about to test one's automation skill using superb automation tools which salesforce provide. So, here i'm going to discuss every problem statements / business requirements of Process Automation Specialist superbadge and convert them into a problem solving flow. I would rather say read twice or thrice unless you are not clear with problem statement /requirement to every challenges of this superbadge, doing so, will give you a clear picture  of problem statement. Challenge-1 : Automate Leads Step-1 :  Validation rule on Lead to verify Country and State field. Lead Country must be either US , USA or United State or it can be blank.  Lead State must be valid 2-digit US state.                Steps-2 : Create Two Queues 1. Rainbow Sales. 2. Assembly System Sales. Create an lead assignment rule and make 2 rules entries and give order accordingly. Based on LeadSource value lead should be a...
Read more

How to show or hide a particular section of Visualforce Page dependent upon picklistfield value

-
Image
In this example, I am going to explain that how to show/hide a particular section of Vf Page that depends on a picklist field value i.e. for a specific picklist value you are showing/hiding a particular part of a VF Page. This can be achieved by using both the Standard Controller and as well as Custom controller functionality. Here I am using Standard Controller functionality. VF Page--- < <apex:page standardController="Contact">   <apex:form id="frm">       <apex:pageBlock >           <apex:pageBlockSection >               <apex:inputField value="{!contact.LeadSource}">                   <apex:actionSupport event="onchange" reRender="frm"/>               </apex:inputField>            </apex:pageBlockSection>      ...
Read more