You need to sign in to do that
Don't have an account?
vandana raju
search for a value in 2 million records
Hi
I am trying to understand how to go about below issue.
I have 2 million historical records in account object.
I have as follows:
If the number of rows is less than or equal to 50000 then its fine but if number of rows is more than 50000 then I will have to use a batch apex.
Now assuming 1 lakh rows are returned then how can I hold this result information in batch apex?
I may want to show these records in a PDF or excel.
I really hope I am very clear.
Please let me know.
I am trying to understand how to go about below issue.
I have 2 million historical records in account object.
I have as follows:
public class somecontroller { public String searchstring{get;set;} public list<Account> acc{get;set;} public somecontroller(ApexPages.StandardController controller) {} public PageReference Search() { string searchquery='select ID,Name from Account where name like \'%'+String.escapeSingleQuotes(searchstring)+'%\' '; acc= Database.query(searchquery); return null; } } <apex:page standardController="Account" extensions="SomeController"> <apex:form> <apex:inputText value="{!SearchString}" label="Enter Account Name"/> <apex:commandButton value="Search records" action="{!search}"/> <apex:commandButton value="Clear records" action="{!search}"/> <apex:pageBlock title="Search Result"> <apex:pageblockTable value="{!acc}" var="a"> <apex:column> <apex:outputlink value="/{!a.id}">{!a.Name}</apex:outputlink> </apex:column> <apex:column value="{!a.id}"/> </apex:pageBlockTable> </apex:pageBlock>
If the number of rows is less than or equal to 50000 then its fine but if number of rows is more than 50000 then I will have to use a batch apex.
Now assuming 1 lakh rows are returned then how can I hold this result information in batch apex?
I may want to show these records in a PDF or excel.
I really hope I am very clear.
Please let me know.