Store and display batch job status history records for more than the default 7 days storage from salesforce generic object: AsyncApexJob using LWC

Kajal Ghosh — Tue, 28 Apr 2026 12:49:34 +0000

Salesforce has limitation of storing the history of all the background jobs status for 7 days only, so if you need to display a report for project or security reasons, you can't view the older data. Hence this solution was implemented to store all the daily batch job records from AsyncApexJob (which is a generic object of salesforce to store all the information of all the apex asynchronous batch jobs for 7 days only) and store it in a custom object created to store them. Then we have created a LWC to view those old records based on date filters and exporting them to excel file with pagination option.

First step is to create a custom object: Async_Job_Record__c to store daily the records from AsyncApexJob standard object of salesforce to store all the information of all the jobs.

Next add sheetjs library to our org:
Exporting Salesforce data into Excel has never been easier! Whether you're working with large volumes of lead data or just need a quick export feature, combining Lightning Web Components (LWC) with SheetJS gives you a powerful and seamless solution.
step-by-step guide:
Create an Apex Class to fetch data
Add the SheetJS Library in Salesforce
Create a LWC Component to Export Data
Test the Excel sheet generation

Sheet JS Library Method Usage
json_to_sheet - This will convert the lead data to a worksheet
book_new - It will create a new workbook
book_append_sheet - It will append the sheet to the workbook
writeFile - It will generate an Excel file with the workbook.

· Step: Add the SheetJS Library in Salesforce.
· The SheetJs library can be downloaded from the GitHub repository. However, we need a pro version to style records in an Excel sheet. The pro version will also support implementation.

LWC: BatchJobStatus
HTML part: BatchJobStatus.html

            <div class="slds-col slds-size_1-of-4">
                <lightning-input 
                    type="date" 
                    label="Start Date" 
                    onchange={handleStartDateChange}>
                </lightning-input>
            </div>

            <div class="slds-col slds-size_1-of-4">
                <lightning-input 
                    type="date" 
                    label="End Date" 
                    onchange={handleEndDateChange}>
                </lightning-input>
            </div>

            <div class="slds-col slds-size_1-of-4">
                <lightning-combobox
                    name="fieldSelect"
                    label="Select Apex Class"
                    value={selectedValue}
                    placeholder="Select an Apex Class"
                    options={dropdownOptions}
                    onchange={handleChange}>
                </lightning-combobox>
            </div>

            <div class="slds-col slds-size_1-of-4 slds-align-bottom">
                <lightning-button 
                    label="Apply Filter" 
                    onclick={applyFilter}>
                </lightning-button>
            </div>

        </div>
    </div>
    <div class="slds-m-around_medium">           
        <div class="slds-m-top_medium">
            <template if:true={batchjobStatusData}>
                <lightning-datatable
                    key-field="Id"
                    data={batchjobStatusData}
                    columns={columns}
                    hide-checkbox-column="true"
                ></lightning-datatable>
                <div class="slds-m-top_medium slds-align_absolute-center">
                    <span class="slds-m-horizontal_small">Page {currentPage} of {totalPages}</span>
                    <lightning-button label="Next"
                                    icon-name="utility:chevronright"
                                    icon-position="right"
                                    onclick={handleNext}
                                    disabled={isLastPage}>
                    </lightning-button>
                </div>
                <div>
                    <lightning-button variant="brand" label="Export XLSX data" title="Export XLSX Data" onclick={handleExport}></lightning-button>
                </div>
            </template>
            <template if:true={error}>
                <p class="slds-text-color_error">{error}</p>
            </template>
        </div>
    </div>
</lightning-card>

.js file:

import { LightningElement, wire, api, track } from 'lwc';
import getDistinctFieldValues from '@salesforce/apex/BatchJobStatus.getDistinctFieldValues';
import getAsyncJobs from '@salesforce/apex/BatchJobStatus.getAsyncJobs';
import getTotalAsyncJobsCount from '@salesforce/apex/BatchJobStatus.getTotalAsyncJobsCount';
import SHEETJS from '@salesforce/resourceUrl/SheetJs';
import { loadScript } from 'lightning/platformResourceLoader';

export default class BatchJobStatus extends LightningElement {

    @track startDate;
        @track endDate;
        @track records;
        @track error;
        @api deploymentId; 
        @track batchjobStatusData = [];

        @track currentPage = 1;
        @track pageSize = 100; // Fetch 100 records per page
        @track totalRecords = 0;
        @track totalPages = 0;

        lastRecordId = null;
        // Boolean flag to check if there are more records available to load
        hasMoreRecords = true;

        @track allRecords = []; // Accumulated records from all pages

        sheetJsInitialized = false;

        // Define columns for lightning-datatable (adjust based on your object's fields)
        columns = [    
            { label: 'Id', fieldName: 'Id', type: 'Id' },        
            { label: 'Submitted Date', fieldName: 'CreatedDate', type: 'date' },
            { label: 'Job Type', fieldName: 'JobType', type: 'text' },
            { label: 'Status', fieldName: 'Status', type: 'text' },
            { label: 'Total Batches', fieldName: 'TotalJobItems', type: 'text' },
            { label: 'Batches Processed', fieldName: 'JobItemsProcessed', type: 'text' },
            { label: 'Failures', fieldName: 'NumberOfErrors', type: 'text' },
            { label: 'Completed Date', fieldName: 'CompletedDate', type: 'date' },
            { label: 'Submitted By', fieldName: 'CreatedBy', type: 'text' },            
            { label: 'FileName', fieldName: 'FileName', type: 'text' },
            { label: 'Apex Job Id', fieldName: 'ApexJobId', type: 'text' }
        ];
    columnHeader = ['Submitted Date', 'Job Type', 'Status', 'Total Batches','Batches Processed', 'Failures', 'Completed Date', 'Submitted By', 'FileName','Apex Job Id']

    dropdownOptions = [];
    selectedValue = '';

    @wire(getDistinctFieldValues)
    wiredOptions({ error, data }) {
        if (data) {
            this.dropdownOptions = data;
        } else if (error) {
            console.error('Error retrieving distinct values:', error);
        }
    }

    handleChange(event) {
        this.selectedValue = event.detail.value;
        console.log('Selected Value:', this.selectedValue);
    }
        handleStartDateChange(event) {
            this.startDate = event.target.value;
        }

        handleEndDateChange(event) {
            this.endDate = event.target.value;
        }

        applyFilter() {       
            this.lastRecordId = null; 
            this.allRecords = [];  
            this.fetchTotalRecords();

        }

        connectedCallback() {
            if (!this.sheetJsInitialized) {
                loadScript(this, SHEETJS)
                    .then(() => {
                        this.sheetJsInitialized = true;
                        console.log('SheetJS loaded');
                    })
                    .catch((error) => {
                        console.error('Error loading SheetJS', error);
                    });
            }
            this.fetchTotalRecords();

        }

    fetchTotalRecords() {
        this.currentPage = 1;
        getTotalAsyncJobsCount({ 
                startDate: this.startDate,
                endDate: this.endDate,
                selectedValue: this.selectedValue})
            .then(result => {
                this.totalRecords = result;
                this.totalPages = Math.ceil(this.totalRecords / this.pageSize);
                this.fetchRecords();
            })
            .catch(error => {
                console.error('Error fetching total records:', error);
            });
    }

    fetchRecords() {

        console.log('Selected record id:', this.lastRecordId);
        getAsyncJobs({ 
                startDate: this.startDate,
                endDate: this.endDate,
                selectedValue: this.selectedValue,
                pageSize: this.pageSize, 
                lastRecordId: this.lastRecordId })
            .then(result => {
                if (result && result.length > 0) {

                this.batchjobStatusData = result.map(item => ({
                    ...item,
                    StartDate: item.StartDate
                }));
                this.error = undefined;
                 // Accumulate data: This adds the current page's data to the allRecords array.
                // You might want to clear and rebuild allRecords if navigating back and forth
                // or if the data can change on the server.

                if(this.allRecords.length === 0){
                    this.allRecords = [...result]; 
                }
                else{

                    this.allRecords = [...this.allRecords, ...result]; 
                }

                // Track last record Id for next page
                this.lastRecordId = result[result.length - 1].Id;
                if (result.length === this.totalRecords) {
                    this.hasMoreRecords = false;
                } else {
                    this.hasMoreRecords = true;
                }

            }
            else{
                this.batchjobStatusData = [];
                this.lastRecordId = null;
            }            
            })
            .catch(error => {

                this.error = error.body.message;
                this.records = undefined;
            });
    }

    handlePrevious() {
        if (this.currentPage > 1) {
            this.currentPage--;
            this.fetchRecords();
        }
    }

    handleNext() {
        console.log('current pages'+ this.currentPage);
        console.log('total pages'+ this.totalPages);
        if (this.currentPage < this.totalPages) {
            this.currentPage++;
            this.fetchRecords();
        }
    }

    get isFirstPage() {
        return this.currentPage === 1;
    }

    get isLastPage() {
        return this.currentPage === this.totalPages;
    }

    exportContactData(){
        // Prepare a html table
        let doc = '<table>';
        // Add styles for the table
        doc += '<style>';
        doc += 'table, th, td {';
        doc += '    border: 1px solid black;';
        doc += '    border-collapse: collapse;';
        doc += '}';          
        doc += '</style>';
        // Add all the Table Headers
        doc += '<tr>';
        this.columnHeader.forEach(element => {            
            doc += '<th>'+ element +'</th>'           
        });
        doc += '</tr>';
        // Add the data rows
        this.batchjobStatusData.forEach(record => {
            doc += '<tr>';
            doc += '<th>'+record.Id+'</th>'; 
            doc += '<th>'+record.CreatedDate+'</th>'; 
            doc += '<th>'+record.JobType+'</th>'; 
            doc += '<th>'+record.Status+'</th>';
            doc += '<th>'+record.TotalJobItems+'</th>'; 
            doc += '<th>'+record.JobItemsProcessed+'</th>'; 
            doc += '<th>'+record.NumberOfErrors+'</th>'; 
            doc += '<th>'+record.CompletedDate+'</th>';
            doc += '<th>'+record.CreatedBy+'</th>';
            doc += '<th>'+record.FileName+'</th>';
            doc += '<th>'+record.ApexJobId+'</th>'; 
            doc += '</tr>';
        });
        doc += '</table>';
        var element = 'data:application/vnd.ms-excel,' + encodeURIComponent(doc);
        let downloadElement = document.createElement('a');
        downloadElement.href = element;
        downloadElement.target = '_self';
        // use .csv as extension on below line if you want to export data as csv
        downloadElement.download = 'Apex Job Data.xls';
        document.body.appendChild(downloadElement);
        downloadElement.click();
    }

    handleExport() {
        const worksheetData = [];
        console.log('Method called');

        if (!this.sheetJsInitialized) {
            console.warn('SheetJS library not loaded yet');
            return;
        }

        if (!this.allRecords || this.allRecords.length === 0) {
            console.warn('No data available to export');
            return;
        }

        for (const record of this.allRecords) {
            worksheetData.push({
                "Id": record.Id,
                "Submitted Date": record.CreatedDate,
                "Job Type": record.JobType,
                "Status":record.Status,
                "Total Batches": record.TotalJobItems,
                "Batches Processed": record.JobItemsProcessed,
                "Failures":record.NumberOfErrors,
                "Completed Date": record.CompletedDate,
                "Submitted By": record.CreatedBy,
                "File Name":record.FileName,
                "Apex Job Id":record.ApexJobId            
            });
        }

        const data = JSON.parse(JSON.stringify(worksheetData));
        console.log('Data to export:', data);

        const ws = XLSX.utils.json_to_sheet(data);
        console.log('Worksheet created:', ws);

        const wb = XLSX.utils.book_new();
        XLSX.utils.book_append_sheet(wb, ws, 'Apex Batch Jobs');

        XLSX.writeFile(wb, 'BatchJobExport.xlsx');
    }

        /**
     * allLoaded getter checks if all records have been loaded.
     * @return {boolean} – True if all records are loaded, false otherwise.
     */
    get allLoaded() {
        // Returns true if there are no more records to load and at least one record is present
        return !this.hasMoreRecords && this.allRecords.length > 0;
    }
}

Apex class:
processAsyncJobBatch: Schedule class to store the daily asynchronous apex job status to a stagging custom object: Async_Job_Record__c, created for this implementation.

public class processAsyncJobBatch implements Schedulable{

   public void execute(SchedulableContext SC) {
        // Query AsyncApexJob records based on job type
        List<AsyncApexJob> asyncJobs = [
            SELECT Id, CreatedDate,CreatedById, CreatedBy.Name, JobType, Status, JobItemsProcessed, 
                   TotalJobItems, NumberOfErrors, CompletedDate,  ApexClassId, ApexClass.Name
            FROM AsyncApexJob 
WHERE JobType IN ('BatchApex') // Filter relevant job types
            AND ApexClass.Name <> 'StProjectQueueFactoryJob'
            AND CreatedDate = TODAY
            ORDER BY CreatedDate DESC
        ];
        //bulkify the code: Write Apex to handle collections of records (lists/maps) rather than processing records one by one in a loop.
        List<Async_Job_Record__c> newRecords = new List<Async_Job_Record__c>();
        for (AsyncApexJob aajs : asyncJobs) {
            newRecords.add(new Async_Job_Record__c(
                       Name='ajrs' + aajs.Id,
                                                          Apex_Job_ID__c=aajs.Id,
                                                          ApexClassName__c=aajs.ApexClass.Name,
                                                          CompletedDateTime__c=aajs.CompletedDate,
                                                          CreatedUserId__c=aajs.CreatedById,
                                                          CreatedUserName__c=aajs.CreatedBy.Name,
                                                          CreatedDateTime__c=aajs.CreatedDate,
                                                          JobType__c=aajs.JobType,
                                                          Status__c=aajs.Status,
                                                          TotalJobItems__c=aajs.TotalJobItems,
                                                          JobItemsProcessed__c=aajs.JobItemsProcessed,
                                                          NumberOfErrors__c=aajs.NumberOfErrors));     
        }
        if (!newRecords.isEmpty()) {
            insert newRecords;
        }
   }

}

processAsyncJobBatchTest: Test class for the above scheduled apex class.

@isTest
public class processAsyncJobBatchTest {

    @isTest
    public static void testSchedule(){                
        Test.startTest();
        User currentUser= [select id from User where id=:UserInfo.getUserId() limit 1];
        Contract__c contract = new Contract__c();
        contract.Name = 'Text Contract';
        insert contract;

        stdraw__Approval_Process_Template__c apt = new stdraw__Approval_Process_Template__c();
        apt.stdraw__Allow_Recalls__c = true;
        apt.stdraw__Active__c = true;
        apt.stdraw__Approval_Process_Template_Name__c = 'test template';
        apt.stdraw__Description__c = 'Test Description';
        apt.stdraw__Entry_Criteria__c = null;
        apt.stdraw__Object_API__c = 'sitetracker__Finance__c';
        apt.stdraw__Object_Name__c = 'Finance';
        insert apt;


        stdraw__Steps_Template__c step1 = new stdraw__Steps_Template__c();
        step1.stdraw__Approval_Process_Template__c = apt.Id;
        step1.stdraw__Approval_Type__c = 'First';
        step1.stdraw__Days_to_Review__c = 5;
        step1.stdraw__Days_to_Review_Type__c = 'Business Days';
        step1.stdraw__Next_Step_Template__c = null;
        step1.stdraw__Previous_Step_Template__c = null;
        step1.stdraw__Step_Template_Name__c = 'Step 1';
        step1.stdraw__Do_Not_Send_Emails__c = true;
        insert step1;

        stdraw__Approver_Template__c at1 = new stdraw__Approver_Template__c();
        at1.stdraw__Step_Template__c = step1.Id;
        at1.stdraw__User__c = UserInfo.getUserId();
        at1.stdraw__Object_API__c = 'Sitetracker__Finance__c';
        insert at1;


        sitetracker__Site__c site= new sitetracker__Site__c();
        site.sitetracker__Site_Type__c='SW';
        site.sitetracker__City__c='testCity';
        site.Name='testName';
        site.Site_Operator__c='Test';
        insert site;


        sitetracker__Project_Template__c pTemplate= new sitetracker__Project_Template__c();
        pTemplate.Name='testPT';
        pTemplate.sitetracker__Active__c=true;
        insert pTemplate;

        sitetracker__Project_Price_Book__c stprbk = new sitetracker__Project_Price_Book__c ();
        stprbk.Name='testPB';
        stprbk.sitetracker__Project_Template__c=pTemplate.ID;
        insert stprbk;      

        sitetracker__Pricebook_Item__c stprc = new sitetracker__Pricebook_Item__c ();
        stprc.Name='testDV';
        stprc.sitetracker__Project_Price_Book__c=stprbk.ID;
        stprc.ASP_PO_Required__c=true;
        stprc.SWC_PO_Required__c=true;
        stprc.Customer_PO_Required__c=true;
        stprc.deliverable_type__c = 'SWC';
        stprc.Approval_Process_Template__c = apt.Id;
        stprc.Contract__c = contract.Id;
        stprc.Multi_Contract__c = Test Contract';
        insert stprc;

       Account acc = new Account();
        acc.Name='ACC';
        insert acc;

  Account acc1 = new Account();
        acc1.Name='3rd Party';
        insert acc1;

        Pricing__c prc= new Pricing__c();
        prc.Price_Book_Item__c=stprc.Id;
        prc.Account__c = acc.id;
  prc.Contract__c = 'Test Contract';
        prc.Is_Active__c = true;
        insert prc;   

  Contract__c Con = new Contract__c();
  Con.name='Test Contract';

        MP_Code__c MPCode = new MP_Code__c();
        MPCode.name = 'MPCode 1';
        MPCode.Programme__c = 'Test Programme';
        Insert MPCode;

        sitetracker__Project__c stProject= new sitetracker__Project__c();
        stProject.sitetracker__Site__c=site.Id;
        stProject.sitetracker__ProjectTemplate__c=pTemplate.id;
        stProject.account__c = acc.id;
  stproject.SWC_Account__c = acc1.id;
        stProject.Instruction_Received_A__c=Date.newInstance(2020, 09, 13);
        stProject.Contract__c=Con.ID;
        stProject.sitetracker__Project_Price_Book__c=stprbk.ID;
        stProject.Customer_Deliverable_Primary__c = stprc.Id;
        stProject.MP_Project__c =  MPCode.Id;  
        insert stProject;

        Work_Instruction__c WI = new Work_Instruction__c();
        WI.Cell_ID__c = site.Id;
        WI.Work_Instruction_Status__c='WIP';
        WI.Project__c=stProject.Id;
        insert WI;

        sitetracker__Purchase_Order__c PO1 = New sitetracker__Purchase_Order__c();
        PO1.Name = 'PO-01';
        PO1.MP_Code__c = MPCode.Id;
        PO1.Price_Book_Item__c = stprc.Id;
        PO1.PO_Status__c = 'Active';
        PO1.Contract__c = Con.Id;
        PO1.Quantity__c = 10;
        Insert PO1;

        sitetracker__Finance__c fin= new sitetracker__Finance__c();
        fin.sitetracker__Project_Link__c=stProject.Id;
        fin.sitetracker__Pricebook_Item__c=stprc.Id;
        fin.Site__c = site.Id;
        fin.Customer_Purchase_Order__c = PO1.Id; 
        insert fin;

        sitetracker__Finance__c finItem = [select id,Approval_Process__c from sitetracker__Finance__c where id =:fin.Id];
        system.debug('Approval Process: '+finItem.Approval_Process__c);

        list<Id> approvalProcessIds = new list<id>();

        stdraw__Steps__c step = new stdraw__Steps__c();
        step.stdraw__Approval_Process__c=finItem.Approval_Process__c;
        step.stdraw__Approval_Type__c = 'First';
        step.stdraw__Step_Template__c = step1.Id;
        step.stdraw__Step_Name__c = 'Step-001';
        insert Step;

        stdraw__Approver__c approver = new stdraw__Approver__c();
        approver.stdraw__Approver_Template__c = at1.Id;
        approver.stdraw__User__c = currentUser.Id;
        approver.stdraw__Status__c = 'Pending' ;
        approver.stdraw__Step__c  = step.Id;  
        approver.stdraw__Object_API__c = 'sitetracker__Finance__c';
        insert approver;

        Set<Id> currentFailedApprovalRecordIds = new Set<Id>();
        Failed_Approval_Batch__c currentFailedApprovalBatch = new Failed_Approval_Batch__c();
            currentFailedApprovalBatch.Name = UserInfo.getName() + ' - ' + Datetime.now().format('yyyy-MM-dd HH:mm:ss');
            currentFailedApprovalBatch.Original_User_Email__c = UserInfo.getUserEmail();
            currentFailedApprovalBatch.Approval_Comment__c = '';
   Map<Id, String>m_approverIdErrorMessage = new Map<Id, String>();
         m_approverIdErrorMessage.put(approver.Id, 'Test failure');
            for(Id approverId : m_approverIdErrorMessage.keySet()) {
                currentFailedApprovalRecordIds.add(approverId);
            }
            currentFailedApprovalBatch.Record_IDs__c = String.join(new List<Id>(currentFailedApprovalRecordIds), ',');
  insert currentFailedApprovalBatch;

        Set<Id> approvalsToRetry = new Set<Id>();

            for(String failedApproval : currentFailedApprovalBatch.Record_IDs__c.split(',')){
                approvalsToRetry.add((Id)failedApproval);
            }

        MassApproversBatchV2 myBatchObject = new MassApproversBatchV2(approvalsToRetry, currentFailedApprovalBatch); 
        Id batchId = Database.executeBatch(myBatchObject);

        processAsyncJobBatch sh1 = new processAsyncJobBatch();
        String sch = '0 0 2 * * ?'; 
        String jobId = system.schedule('Test Asyncjob Check', sch, sh1); 
         // 3. Verify the job is scheduled
        CronTrigger ct = [SELECT Id, CronExpression, TimesTriggered, NextFireTime FROM CronTrigger WHERE Id = :jobId];
        System.assertEquals(sch, ct.CronExpression);

        Test.stopTest();

         // Query your custom object to verify the inserted records
        List<Async_Job_Record__c> customRecords = [SELECT Id, Name, Apex_Job_ID__c, Status__c FROM Async_Job_Record__c];

        // Assertions to verify the custom object records
        System.assertNotEquals(0, customRecords.size(), 'No custom records were created by the scheduled job.');

    }

}

Schedule the above schedulable apex class daily as below:

BatchJobStatus: Apex class with aura methods which will be called from LWC component to display the data based on filters. export data using xlsx and pagination with Salesforce SOQL limit and offset clauses.

Have you ever tried implementing server-side pagination using Apex with Salesforce SOQL limit and offset clauses? If yes, then you might already know that Salesforce SOQL doesn't support offset values more than 2000. That means you can't load more than 2000 records even if they are spread across multiple pages.
When building modern Salesforce Lightning Web Components (LWCs), one essential UX feature is lazy loading (or infinite scrolling).

It helps load data incrementally as users scroll - improving performance, reducing query load, and creating a smooth user experience.

A common first attempt at building pagination in Salesforce looks something like this:

SELECT Id, Name, Email FROM Contact LIMIT 50 OFFSET 100
At first glance, it seems perfect - you simply skip the first 100 records and fetch the next 50 for your next page or scroll.

However, this approach quickly runs into serious performance and scalability issues when used in Lightning Web Components (LWC) or any large dataset scenario.
Offset Limitations

In short - OFFSET pagination breaks for large datasets and hurts performance even before that.
Instead of relying on "skip and fetch," we can use keyset pagination, also known as cursor-based pagination.

"Fetch the next N records where Id (or another key) is greater than the last record we already loaded."

This approach uses indexed, unique fields which is Id field. This ensures consistent, fast, scalable queries. There is no OFFSET limit.

The key part of the solution is to pass the Id of the last or the first record from the current page based on whether we are trying to load the next or the previous page of records.
Once we have the Id of the record for an already loaded page, page size and direction, we can use SOQL with filters on the Id field, limit and order by clauses to load the next set of records.

For the first load, lastRecordId is null → fetches the first batch.
On scroll, we pass the last record's Id → fetches the next batch.

First of all, we find the total number of records for the specified object in the system. We can do that using the following method:

Calculate the total pages based on the total records and the page size
Next, we calculate the total number of pages based on the total number of records and the specified page size. We can use the following formula to calculate that:

Integer totalPages = (Integer) Math.ceil((Decimal) totalRecords / pageSize);

public with sharing class BatchJobStatus {
    @AuraEnabled(cacheable=true)
    public static List<Map<String, String>> getDistinctFieldValues() {
        List<Map<String, String>> options = new List<Map<String, String>>();
        Set<String> distinctValues = new Set<String>(); // Use a Set to ensure uniqueness
List<Async_Job_Record__c> asyncBatchJobs = Database.query('SELECT ApexClassName__c FROM Async_Job_Record__c');

        for (Async_Job_Record__c aajs : asyncBatchJobs) {
            if (aajs.ApexClassName__c != null) { // Add null check for robustness
                distinctValues.add(aajs.ApexClassName__c);
            }
        }

        // Convert the Set to a List of Maps for LWC consumption
        options.add(new Map<String, String>{'label' => 'None', 'value' => null});
        for (String value : distinctValues) {
            options.add(new Map<String, String>{'label' => value, 'value' => value});
        }
        return options;
    }

    // Inner class to represent batchJobStatus structure for easier handling
    public class batchJobStatus {
        @AuraEnabled public Id Id;
        @AuraEnabled public String Status;
        @AuraEnabled public DateTime CreatedDate;
        @AuraEnabled public DateTime CompletedDate;
        @AuraEnabled public String CreatedBy;
        @AuraEnabled public String JobType;
        @AuraEnabled public String FileName;
        @AuraEnabled public Decimal JobItemsProcessed; 
        @AuraEnabled public Decimal TotalJobItems;
        @AuraEnabled public Decimal NumberOfErrors;
        @AuraEnabled public String ApexJobId;
    }

    @AuraEnabled(cacheable=true)
    public static List<batchJobStatus> getAsyncJobs(DateTime startDate, DateTime endDate, String selectedValue, Integer pageSize, Id lastRecordId) {

        // 1. Prepare the fixed string values
        List<String> statusValues = new List<String>{'ScheduledApex', 'BatchApex', 'Future', 'Queueable'};

        // 2. Format the string values for the IN clause
        List<String> quotedStatusValues = new List<String>();
        for (String s : statusValues) {
            quotedStatusValues.add('\'' + String.escapeSingleQuotes(s) + '\'');
        }
        String inClauseValues = String.join(quotedStatusValues, ',');

        String query = 'SELECT Id, CreatedDateTime__c, CreatedUserId__c, CreatedUserName__c, JobType__c, Status__c, JobItemsProcessed__c, '+
                   'TotalJobItems__c, NumberOfErrors__c, CompletedDateTime__c,  Apex_Job_ID__c, ApexClassName__c '+
              'FROM Async_Job_Record__c '+
           'WHERE JobType__c IN (' + inClauseValues + ')';
        List<String> conditions = new List<String>();

        if (startDate != null) {
            query += ' AND CreatedDateTime__c >= ' + startDate.formatGMT('yyyy-MM-dd\'T\'HH:mm:ss\'Z\'');
        }
        if (endDate != null) {
   Date datePart = endDate.date();

            // 2. Create a new Time instance for 11:59:59 PM
            // Note: Milliseconds are typically 0 when setting to the end of the second.
            Time endOfDayTime = Time.newInstance(23, 59, 59, 0); 

            // 3. Combine Date and Time to create the new DateTime
            DateTime endOfDayDateTime = DateTime.newInstance(datePart, endOfDayTime);

            query += ' AND CreatedDateTime__c <= ' + endOfDayDateTime.formatGMT('yyyy-MM-dd\'T\'HH:mm:ss\'Z\'');
        }

        if (String.isNotBlank(selectedValue)) {
            query += ' AND ApexClassName__c = \'' + selectedValue + '\'';
        }
        if (lastRecordId != null) {
            query += ' AND Id < :lastRecordId';
        }
        query += ' ORDER BY Id DESC LIMIT ' + pageSize; // Add a limit for performance
        List<batchJobStatus> batchJobStats = new List<batchJobStatus>();
         // Query AsyncApexJob records based on job type
        List<Async_Job_Record__c> asyncBatchJobs = Database.query(query);
        for (Async_Job_Record__c aajs : asyncBatchJobs) {
            batchJobStatus bjs = new batchJobStatus();
            bjs.Id= aajs.Id;
            bjs.JobType= aajs.JobType__c;
            bjs.Status= aajs.status__c;            
            bjs.CreatedDate= aajs.CreatedDateTime__c;
            bjs.CreatedBy= aajs.CreatedUserName__c;
            bjs.CompletedDate= aajs.CompletedDateTime__c;
            bjs.JobItemsProcessed= aajs.JobItemsProcessed__c;
            bjs.TotalJobItems= aajs.TotalJobItems__c;
            bjs.NumberOfErrors= aajs.NumberOfErrors__c;
            bjs.FileName= aajs.ApexClassName__c; 
            bjs.ApexJobId= aajs.Apex_Job_ID__c;
            batchJobStats.add(bjs);
        }
        return batchJobStats;
    }

    @AuraEnabled(cacheable=true)
    public static Integer getTotalAsyncJobsCount(DateTime startDate, DateTime endDate, String selectedValue) {
        // Add error handling and security checks as needed
        List<String> statusValues = new List<String>{'ScheduledApex', 'BatchApex', 'Future', 'Queueable'};

        // 2. Format the string values for the IN clause
        List<String> quotedStatusValues = new List<String>();
        for (String s : statusValues) {
            quotedStatusValues.add('\'' + String.escapeSingleQuotes(s) + '\'');
        }
        String inClauseValues = String.join(quotedStatusValues, ',');
        String query = 'SELECT COUNT() '+
              'FROM Async_Job_Record__c '+
           'WHERE JobType__c IN (' + inClauseValues + ')';
        List<String> conditions = new List<String>();
        if (startDate != null) {
            query += ' AND CreatedDateTime__c >= ' + startDate.formatGMT('yyyy-MM-dd\'T\'HH:mm:ss\'Z\'');
        }
        if (endDate != null) {
   Date datePart = endDate.date();

            // 2. Create a new Time instance for 11:59:59 PM
            // Note: Milliseconds are typically 0 when setting to the end of the second.
            Time endOfDayTime = Time.newInstance(23, 59, 59, 0); 

            // 3. Combine Date and Time to create new DateTime
            DateTime endOfDayDateTime = DateTime.newInstance(datePart, endOfDayTime);

            query += ' AND CreatedDateTime__c <= ' + endOfDayDateTime.formatGMT('yyyy-MM-dd\'T\'HH:mm:ss\'Z\'');
        }

        if (String.isNotBlank(selectedValue)) {
            query += ' AND ApexClassName__c = \'' + selectedValue + '\'';
        }

        Integer totalRecordCount = Database.countQuery(query);
        return totalRecordCount; 
    }
}

Test class:

@isTest
public class BatchJobStatusTest {
   @isTest(SeeAllData=true)
        static void testGetAsyncApexJobs() {
            // No need to create AsyncApexJob records directly in tests
            // as they are system-generated.
            // However, you can create a scheduled job to ensure there's data.
            System.schedule('Test Scheduled Job', '0 0 0 1 1 ? 2050', new TestSchedulableClass());
   Date stDate = Date.newInstance(2025, 1, 1);           
            Date endDate = Date.newInstance(2025, 12, 11);
            String selectedValue = '';
            Set<String> distinctValues = new Set<String>(); // Use a Set to ensure uniqueness
            List<Async_Job_Record__c> asyncBatchJobClasses = Database.query('SELECT ApexClassName__c FROM Async_Job_Record__c');

            for (Async_Job_Record__c aajs : asyncBatchJobClasses) {
                if (aajs.ApexClassName__c != null) { // Add null check for robustness
                    distinctValues.add(aajs.ApexClassName__c);
                }
            }
            // Convert the Set to a List
   List<String> myStringList = new List<String>(distinctValues);
            selectedValue = myStringList[0];
            Integer pageSize = BatchJobStatus.getTotalAsyncJobsCount(stDate,endDate,selectedValue);
            Integer offset = 0 ;
            Test.startTest();
            Id lastRecord;

            List<BatchJobStatus.batchJobStatus> jobs = BatchJobStatus.getAsyncJobs(stDate,endDate,selectedValue,pageSize, lastRecord);            
            Test.stopTest();

            System.assertNotEquals(null,jobs, 'The list of AsyncApexJob should not be null.');
            // 1. Prepare the fixed string values
            List<String> statusValues = new List<String>{'ScheduledApex', 'BatchApex', 'Future', 'Queueable'};

            // 2. Format the string values for the IN clause
            List<String> quotedStatusValues = new List<String>();
            for (String s : statusValues) {
                quotedStatusValues.add('\'' + String.escapeSingleQuotes(s) + '\'');
            }
            String inClauseValues = String.join(quotedStatusValues, ',');

            String whereValue = 'MassApproversBatchV2';    
            String query = 'SELECT Id, CreatedDateTime__c, CreatedUserId__c, CreatedUserName__c, JobType__c, Status__c, JobItemsProcessed__c, '+
                       'TotalJobItems__c, NumberOfErrors__c, CompletedDateTime__c,  Apex_Job_ID__c, ApexClassName__c '+
                        'FROM Async_Job_Record__c '+
                        //'WHERE ApexClassName__c =: whereValue';
                        //'WHERE ApexClassName__c =\'MassApproversBatchV2\'';
                        'WHERE JobType__c IN (' + inClauseValues + ')';
            List<String> conditions = new List<String>();
            if (stDate != null) {
                conditions.add('CreatedDate >= :stDate');
            }
            if (endDate != null) {
                conditions.add('CreatedDate <= :endDate');
            }
            if (String.isNotBlank(selectedValue)) {
                 conditions.add('ApexClassName__c = \'' + selectedValue + '\'');
            }
            if (!conditions.isEmpty()) {
                query += ' AND ' + String.join(conditions, ' AND ');
            }

            Map<String, Object> bindVars = new Map<String, Object>();
            bindVars.put('stDate', stDate);
            bindVars.put('endDate', endDate);
            bindVars.put('selectedValue', '');
            List<SObject> records = Database.queryWithBinds(query, bindVars, AccessLevel.USER_MODE);

            query += ' ORDER BY CreatedDate DESC LIMIT 100';
                List<Async_Job_Record__c> asyncBatchJobs = Database.query(query);
                List<BatchJobStatus.batchJobStatus> batchJobStats = new List<BatchJobStatus.batchJobStatus>();
                 for (Integer i = 0; i < asyncBatchJobs.size(); i++) {
                            Async_Job_Record__c aajob = asyncBatchJobs[i];
                            if(aajob!=null){
                                BatchJobStatus.batchJobStatus job = jobs[i];
                                BatchJobStatus.batchJobStatus bjs = new BatchJobStatus.batchJobStatus();
                                bjs.Id= aajob.Apex_Job_ID__c;
                                bjs.JobType= aajob.JobType__c;
                                bjs.Status= aajob.status__c;            
                                bjs.CreatedDate= aajob.CreatedDateTime__c;
                                bjs.CreatedBy= aajob.CreatedUserName__c;
                                bjs.CompletedDate= aajob.CompletedDateTime__c;
                                bjs.JobItemsProcessed= aajob.JobItemsProcessed__c;
                                bjs.TotalJobItems= aajob.TotalJobItems__c;
                                bjs.NumberOfErrors= aajob.NumberOfErrors__c;
                                bjs.FileName= aajob.ApexClassName__c; 
                                batchJobStats.add(bjs);
                     } 
              }

        }

        // A simple schedulable class for testing purposes
        public class TestSchedulableClass implements Schedulable {
            public void execute(SchedulableContext sc) {
                // Do nothing or perform a simple operation for the test
            }
        }        
}

DEV Community: Kajal Ghosh

Store and display batch job status history records for more than the default 7 days storage from salesforce generic object: AsyncApexJob using LWC