[SalesForce] Get more than 2000 record from report in Apex

I want to retrieve more than 2000 records from reports using apex code. I read saleforce report limitation and found 2 different thing.

The API returns up to the first 2,000 report rows.
The number of report rows processed during a synchronous report run count towards the governor limit that restricts the total number of rows retrieved by SOQL queries to 50,000 rows per transaction. This limit is not imposed when reports are run asynchronously.

So that how to implement second point?

Best Answer

you can use a filter on the object id column to exclude the first 2000 results and get the second 2000 until you fetch all the data:

    Reports.ReportResults results = Reports.ReportManager.runReport('00O58000003sea0',true);
    // pars the result to recive the first 2000 ids.
    Reports.ReportFilter RF = new Reports.ReportFilter('ACCOUNT_ID', 'notEqual', ConcatOfReturnIds);
    Reports.ReportMetadata RM = results.getReportMetadata();
    list<Reports.ReportFilter>allfilters = new list<Reports.ReportFilter> {RF};
    allfilters.addAll(RM.getReportFilters());
    RM.setReportFilters(allfilters);
    results = Reports.ReportManager.runReport('00O58000003sea0', RM,true);
    System.debug(LoggingLevel.INFO,'res: '+results.getFactMap());

for more information see here Glazeforce but don't use the callouts - its use less. regards.

Related Solutions

[SalesForce] Problem using AggregateResult in batch apex using Database.Batchable class

With 50 master records each of which can have > 50,000 child records, running the batchable over the child records may make sense. The code would look something like this:

public class MyBatchable implements Database.Batchable<SObject>, Database.Stateful {

    private Map<Id, Parent__c> parents = new Map<Id, Parent__c>();

    public Database.QueryLocator start(Database.BatchableContext context) {
        return Database.getQueryLocator([
                select Parent__c, Amount__c, ...
                from Child__c
                ]);
    }

    public void execute(Database.BatchableContext context, List<Child__c> scope) {
        for (Child__c c : scope) {
            Parent__c p = parents.get(c.Parent__c);
            if (p == null) {
                p = new Parent__c(Id = c.Parent__c);
                parents.put(c.ParentId, p);
            }
            p.Sum__c = add(p.Sum__c, c.Amount__c);
            ...
        }
    }

    public void finish(Database.BatchableContext context) {
        update parents.values();
    }

    private Decimal add(Decimal a, Decimal b) {
        if (a != null && b != null) return a + b;
        else if (a != null) return a;
        else if (b != null) return b;
        else return null;
    }
}

and then execute with the maximum batch size of 2,000.

[SalesForce] First error: Too many query rows: 50001 in a batch apex class without any inner query

AggregateResult does not support a QueryLocator, and the Start method only supports more than 50,000 rows if you use a QueryLocator. The net result is that you cannot batch process aggregate results for more than 50,000 rows. You'll instead want to use Database.Stateful, and iterate over the individual elements to sum them up, and possibly do something with them in the finish method (probably chain to a second batch process).

Best Answer

Related Solutions

[SalesForce] Problem using AggregateResult in batch apex using Database.Batchable class

[SalesForce] First error: Too many query rows: 50001 in a batch apex class without any inner query

Related Topic