You need to sign in to do that
Don't have an account?
Girbson Bijou 8
Display more than 1000 Line in visualforce
Please help me to display more than 1000 lines in a visualforce page.
public class InventoryCentralOficce { public List<AggregateResult> allproduct{get;set;} public InventoryCentralOficce() { allproduct = [ SELECT Product_Hiden_Name__c, UM__c ,SUM(On_Hand__c)onHand, SUM(Pending__c)pending, SUM(Available__c)avail FROM Articles_Containers__c WHERE IsOpened__c = 1 AND FFP_Centers__c = 'Central Office' GROUP BY Product_Hiden_Name__c , UM__c HAVING SUM(On_Hand__c) >0 ORDER BY Product_Hiden_Name__c, UM__c limit 50000]; } }
Per the VF documentation, it clearly states:
In addition to querying many more rows, the readOnly attribute also increases the maximum number of items in a collectionthat can be iterated over using components such as <apex:dataTable>, <apex:dataList>, and <apex:repeat>. This limit increased from 1,000 items to 10,000.
https://developer.salesforce.com/docs/atlas.en-us.pages.meta/pages/pages_controller_readonly_context_pagelevel.htm