I am building a financial report as like below
Since we know we are building for the whole year or two year and since its finacial report the number rows will be heavy. Since its finaicial report we Aggregate to sum the records and as we have millions of records we are sure that number of query rows will cross the governor limit 50001 and that is the issue we are facing currently.
So the solution I saw is using only batch class as there are million of records to aggregate.
Just want to know whether we can call Batch apex from LWC component , wait for the batch apex to finish its operation then finally return back the result to LWC component for display