choudharymanish8585

public class AccountController {
    
    @AuraEnabled
    public static List<Account> getAccountsWithOffset(String pageSize, String pageNumber){
        Integer ps = Integer.valueOf(pageSize);
        Integer pn = Integer.valueOf(pageNumber)-1;
        
        List<Account> accounts = [SELECT
               Id, Name, Phone, Rating, My_Custom_Field__c, Active__c
               FROM Account LIMIT :Integer.valueOf(ps) OFFSET :(ps*pn)];

choudharymanish8585

({
    getAccounts : function(component, helper) {
        var action = component.get("c.getAccountsWithOffset");
        action.setStorable();
        action.setParams({
            'pageSize' : component.get("v.pageSize").toString(),
            'pageNumber' : component.get("v.pageNumber").toString()
        });
        action.setCallback(this,function(response) {
            var state = response.getState();

choudharymanish8585

({
    /*
     * This finction defined column header
     * and calls getAccounts helper method for column data
     * editable:'true' will make the column editable
     * */
	doInit : function(component, event, helper) {        
        component.set('v.columns', [
            {label: 'Name', fieldName: 'Name', type: 'text'},
            {label: 'Phone', fieldName: 'Phone', type: 'phone'},

choudharymanish8585

<aura:component implements="force:appHostable,flexipage:availableForAllPageTypes" 
                access="global" 
                controller="AccountController">
    <aura:attribute name="data" type="Object"/>
    <aura:attribute name="columns" type="List"/>
    <aura:attribute name="recordId" type="String"/>
    
    <aura:attribute name="pageNumber" type="Integer" default="1"/>
    <aura:attribute name="pageSize" type="Integer" default="10"/>
    <aura:attribute name="isLastPage" type="Boolean" default="false"/>