Apex Code Development You need to sign in to do that
Don't have an account?
Javascript remoting - 135 KB limit, 1000 rows - Please help
Hey there, I was hoping to get a hand on how to implement javascript remoting. I have been told that it can be used to get passed the 135 kb view state limit and the 1000 row pageblocktable limit. I have a visualforce page which I have overriden my custom object tab (transactions).
I wanted to test to see if it could handle bulk records as I am yet to release my system, on a side note i also employ Avi's pageblocktable enhancer. On first test after bulk uploading 2000 records i tried opening the tab and it only displayed 20 records, I played around wrote a custom controller (then added to it for all my overriden tabs, added read - only to the tab apex page tag, but I am still having trouble with view state.
Please, i was hoping someone could help me out by guiding me to imeplement javascript remoting, I am very lost in this and have only recently become semi decent in understand apex. Any tips on my code would also be appreciated. Thank you in advance for your help.
Page
class
I wanted to test to see if it could handle bulk records as I am yet to release my system, on a side note i also employ Avi's pageblocktable enhancer. On first test after bulk uploading 2000 records i tried opening the tab and it only displayed 20 records, I played around wrote a custom controller (then added to it for all my overriden tabs, added read - only to the tab apex page tag, but I am still having trouble with view state.
Please, i was hoping someone could help me out by guiding me to imeplement javascript remoting, I am very lost in this and have only recently become semi decent in understand apex. Any tips on my code would also be appreciated. Thank you in advance for your help.
Page
<apex:page Controller="GlobalObject_Query" tabStyle="Transaction__c" readOnly="true">
<apex:stylesheet value="https://ajax.googleapis.com/ajax/libs/jqueryui/1.10.3/themes/ui-lightness/jquery-ui.css"/>
<script>
$j = jQuery.noConflict();
function highlightElem(elem){
$j(elem).parent().parent().parent().find('tr').removeClass('ui-state-highlight');
$j(elem).parent().parent().addClass('ui-state-highlight');
}
</script>
<c:PageBlockTableEnhancerADV targetPbTableIds="pbtTra" pageSizeOptions="25,50,100,250,500,750" defaultPageSize="25" enableExport="False"/>
<apex:sectionheader title="Transactions" subtitle="Home"></apex:sectionheader>
<apex:form >
<apex:pageBlock id="pb" >
<apex:pageBlockTable value="{!GlobalTransactions}" var="Tra" cellPadding="4" border="4" id="pbtTra">
<apex:column headerValue="Transaction" >
<apex:commandLink rerender="Tradetails" oncomplete="highlightElem(this);"> {!Tra.Name}
<apex:param name="Tid" value="{!Tra.id}"/>
</apex:commandLink>
</apex:column>
<!-- <apex:column headervalue="Account" value="{!Tra.Account__c}"/> -->
<apex:column headervalue="Date" value="{!Tra.Date_of_Payment__c}"/>
<apex:column headervalue="Amount" value="{!Tra.Amount__c}"/>
<apex:column value="{!Tra.Method__c}"/>
<!-- <apex:column headervalue="Service" value="{!Tra.Service_Name__c}"/>-->
<apex:column headervalue="Office" value="{!Tra.Office__c}"/>
</apex:pageBlockTable>
</apex:pageBlock>
</apex:form>
<apex:outputPanel id="Tradetails">
<apex:detail subject="{!$CurrentPage.parameters.Tid}" relatedList="True" inlineEdit="True" title="false"/>
</apex:outputPanel>
</apex:page>
class
public class GlobalObject_Query{
//Introduce Objects
public Transaction__c Tra {get;set;}
public Service__c Ser {get;set;}
public Finance__c Fin {get;set;}
public Property__c Prop {get;set;}
public Destiny_Survey__c Sur {get;set;}
public Office_Commission__c OffCom {get;set;}
public Office_Invoice__c OffInv {get;set;}
//Introduce Lists
List<Transaction__c> TransList = new List<Transaction__c>();
List<Service__c> ServList = new List<Service__c>();
List<Finance__c> FinList = new List<Finance__c>();
List<Property__c> PropList = new List<Property__c>();
List<Destiny_Survey__c > SurvList = new List<Destiny_Survey__c >();
List<Office_Commission__c> OffComList = new List<Office_Commission__c>();
List<Office_Invoice__c> OffInvList = new List<Office_Invoice__c>();
//Construct Controller and set variables
public GlobalObject_Query() {
//Transaction
this.Tra = Tra;
this.transList = new List<Transaction__c>();
//Service
this.Ser = Ser;
this.ServList = new List<Service__c>();
//Finance
this.Fin = Fin;
this.FinList = new List<Finance__c>();
//Properties
this.Prop = Prop;
this.PropList = new List<Property__c>();
//Surveys
this.Sur = Sur;
this.SurvList = new List<Destiny_Survey__c >();
//Office Commission
this.OffCom = OffCom;
this.OffComList = new List<Office_Commission__c>();
//Office Invoice
this.OffInv = OffInv;
this.OffInvList = new List<Office_Invoice__c>();
}
//Transaction Queries
public List<Transaction__c> getGlobalTransactions()
{
this.transList.addAll( [SELECT ID, Name, Amount__c, Account__c, Service_Name__c, method__c, Transaction_type__c, date_of_payment__c, Office__c, createddate FROM Transaction__c LIMIT 10000]);
if (this.transList == null || this.transList.isEmpty()) {
return null;
}
return this.transList;
}
//Service Queries
public List<Service__c> getGlobalServices()
{
this.ServList.addAll( [SELECT ID, Name, Account__c, Service_Name__c, Service_Type__c, Start_of_Service__c, Service_Stage__c, Amount_remaining__c, Office__c FROM Service__c LIMIT 10000]);
if (this.ServList == null || this.ServList.isEmpty()) {
return null;
}
return this.ServList;
}
//Finance Queries
public List<Finance__c> getGlobalFinances()
{
this.FinList.addAll( [SELECT ID, Name, Account__c, Finance_Office__c, Finance_Writer__c, Application_Submitted__c , Application_Amount__c, Conditional_Approval__c, Unconditional_Approval__c, Amount_Approved__c, Finance_Settlement__c FROM Finance__c LIMIT 10000]);
if (this.FinList == null || this.FinList.isEmpty()) {
return null;
}
return this.FinList;
}
//Property Queries
public List<Property__c> getGlobalProperties()
{
this.PropList.addAll( [SELECT ID, Account__c, Name, Office__c, Property_Type__c, Property_Full_Address__c, Destiny_Finance__c FROM Property__c LIMIT 10000]);
if (this.PropList == null || this.PropList.isEmpty()) {
return null;
}
return this.PropList;
}
//Survey Queries
public List<Destiny_survey__c> getGlobalSurveys()
{
this.SurvList.addAll( [SELECT ID, Name, Account__c, Office__c, Survey_Type__c, How_likely_are_you_to_refer_Destiny__c FROM Destiny_survey__c LIMIT 10000]);
if (this.SurvList == null || this.SurvList.isEmpty()) {
return null;
}
return this.SurvList;
}
//Office Commission Queries
public List<Office_commission__c> getGlobalOfficeCommissions()
{
this.OffComList.addAll( [SELECT ID, Name, Office__c, Commission_Period_Start__c, Commission_Period_End__c, Total_Professional_Service_Fees_Due__c, Total_Finance_Commissions_Due__c FROM Office_Commission__c LIMIT 10000]);
if (this.OffComList == null || this.OffComList.isEmpty()) {
return null;
}
return this.OffComList;
}
//Office Invoice Queries
public List<Office_Invoice__c> getGlobalOfficeInvoices()
{
this.OffInvList.addAll( [SELECT ID, Name, Office_Invoice_Date__c, Office_Invoice_Amount__c, Office_Invoice_Description__c, Payment_Date__c, Office_Name__c, Office_Commission__c FROM Office_Invoice__c LIMIT 10000]);
if (this.OffInvList == null || this.OffInvList.isEmpty()) {
return null;
}
return this.OffInvList;
}
}
Unfortunately i could not find blog address for you hence posting whole code.
This code is user for sorting and pagination. You can change pageSize variable to any number you want.
This code is well tested so it should guide you.
VF Page:
<apex:page controller="MyPagingController" tabStyle="Account">
<apex:sectionHeader title="Accounts List with Paging"></apex:sectionHeader>
<apex:form >
<apex:pageBlock title="" id="pageBlock">
<div align="right" style="display:{!IF(NOT(ISNULL(accounts)),'block','none')}">
<font size="1pt">
Page #:
<apex:outputLabel value="{!PageNumber}"/>
out of
<apex:outputLabel value="{!totalPageNumber}"/>
</font>
<apex:commandButton value="Previous" action="{!previousBtnClick}" disabled="{!previousButtonEnabled}" reRender="pageBlock"></apex:commandButton>
<apex:commandButton value="Next" action="{!nextBtnClick}" reRender="pageBlock" disabled="{!nextButtonDisabled}" ></apex:commandButton>
</div>
<br/><br/>
<apex:pageBlockTable value="{!accounts}" var="a" rendered="{!NOT(ISNULL(accounts))}" rows="{!PageSize}">
<apex:column >
<apex:facet name="header">
<apex:commandLink action="{!ViewData}" value="Account Name{!IF(sortExpression=='name',IF(sortDirection='ASC','▼','▲'),'')}" id="cmdSort">
<apex:param value="name" name="column" assignTo="{!sortExpression}" ></apex:param>
</apex:commandLink>
</apex:facet>
<apex:outputLink value="/{!a.Id}" target="_blank">{!a.Name}</apex:outputLink>
</apex:column>
<apex:column value="{!a.Phone}">
<apex:facet name="header">
<apex:commandLink action="{!ViewData}" value="Phone{!IF(sortExpression=='Phone',IF(sortDirection='ASC','▼','▲'),'')}">
<apex:param value="Phone" name="column" assignTo="{!sortExpression}" ></apex:param>
</apex:commandLink>
</apex:facet>
</apex:column>
<apex:column value="{!a.BillingCity}">
<apex:facet name="header">
<apex:commandLink action="{!ViewData}" value="Billing City{!IF(sortExpression=='BillingCity',IF(sortDirection='ASC','▼','▲'),'')}">
<apex:param value="BillingCity" name="column" assignTo="{!sortExpression}" ></apex:param>
</apex:commandLink>
</apex:facet>
</apex:column>
<apex:column value="{!a.BillingCountry}">
<apex:facet name="header">
<apex:commandLink action="{!ViewData}" value="Billing Country{!IF(sortExpression=='BillingCountry',IF(sortDirection='ASC','▼','▲'),'')}">
<apex:param value="BillingCountry" name="column" assignTo="{!sortExpression}" ></apex:param>
</apex:commandLink>
</apex:facet>
</apex:column>
</apex:pageBlockTable>
<div align="right" style="display:{!IF(NOT(ISNULL(accounts)),'block','none')}">
<br/>
<font size="1pt">
Page #:
<apex:outputLabel value="{!PageNumber}"/>
out of
<apex:outputLabel value="{!totalPageNumber}"/>
</font>
<apex:commandButton value="Previous" action="{!previousBtnClick}" disabled="{!previousButtonEnabled}" reRender="pageBlock"></apex:commandButton>
<apex:commandButton value="Next" action="{!nextBtnClick}" reRender="pageBlock" disabled="{!nextButtonDisabled}" ></apex:commandButton>
</div>
</apex:pageBlock>
</apex:form>
</apex:page>
CONTROLLER:
public class MyPagingController{
private List<Account> accounts;
private List<Account> pageAccounts;
private String sortDirection = 'ASC';
private String sortExp = 'name';
private Integer pageNumber;
private Integer pageSize;
private Integer totalPageNumber;
public Integer getPageNumber(){
return pageNumber;
}
public String sortExpression {
get{return sortExp;}
set{
if (value == sortExp)
sortDirection = (sortDirection == 'ASC')? 'DESC' : 'ASC';
else
sortDirection = 'ASC';
sortExp = value;
}
}
public String getSortDirection(){
if (sortExpression == null || sortExpression == '')
return 'ASC';
else
return sortDirection;
}
public void setSortDirection(String value){
sortDirection = value;
}
public List<Account> getAccounts(){
return pageAccounts;
}
public Integer getPageSize(){
return pageSize;
}
public Boolean getPreviousButtonEnabled(){
return !(pageNumber > 1);
}
public Boolean getNextButtonDisabled(){
if (accounts == null)
return true;
else
return ((pageNumber * pageSize) >= accounts.size());
}
public Integer getTotalPageNumber(){
if (totalPageNumber == 0 && accounts !=null){
totalPageNumber = accounts.size() / pageSize;
Integer mod = accounts.size() - (totalPageNumber * pageSize);
if (mod > 0)
totalPageNumber++;
}
return totalPageNumber;
}
public MyPagingController() {
pageNumber = 0;
totalPageNumber = 0;
pageSize = 4;
ViewData();
}
public PageReference ViewData(){
accounts = null;
totalPageNumber = 0;
BindData(1);
return null;
}
private void BindData(Integer newPageIndex) {
try{
string sortFullExp = sortExpression + ' ' + sortDirection;
string aName ='AKS foods';
if (accounts == null)
accounts = Database.query('Select id, Name, BillingCity, BillingCountry, Phone from Account order by ' + sortFullExp );
pageAccounts = new List<Account>{};
Transient Integer counter = 0;
Transient Integer min = 0;
Transient Integer max = 0;
if (newPageIndex > pageNumber){
min = pageNumber * pageSize;
max = newPageIndex * pageSize;
}
else{
max = newPageIndex * pageSize; min = max - pageSize;
}
for(Account a : accounts){
counter++;
if (counter > min && counter <= max)
pageAccounts.add(a);
}
pageNumber = newPageIndex;
if (pageAccounts == null || pageAccounts.size() <= 0)
ApexPages.addmessage(new ApexPages.message(ApexPages.severity.INFO,'Data not available for this view.'));
}
catch(Exception ex)
{
ApexPages.addmessage(new ApexPages.message(ApexPages.severity.FATAL,ex.getMessage()));
}
}
public PageReference nextBtnClick() {
BindData(pageNumber + 1);
return null;
}
public PageReference previousBtnClick() {
BindData(pageNumber - 1);
return null;
}
}
change query and pageSize accordigly.