Apex class DML query using bind variable

Question

The line "Integer days =" has an error, which I am trying to bind the Case record id to get "days" to be passed to the "createCase.Date_Due__c = date.today() + days; " Equipment__c is a lookup field on Case to Product2. What is wrong here? Thanks for your help!

public with sharing class MaintenanceRequestHelper {

public static void updateWorkOrders(List<Case> newCase, Map<Id,Case> oldMapCase) {
    List<Case> caseList = new List<Case>();
    for (Case thisCase: newCase)         
    {
     Integer days = [Select Maintenance_Cycle__c from Product2 where id =:thisCase.Equipment__c];

        if (thisCase.Status=='Closed' && oldMapCase.get(thisCase.id).Status != 'Closed'){
            Case createCase = new Case();
            createCase.RecordTypeId = '0124W00000160QvQAI';
            createCase.subject = 'New Case Created';
            createCase.Equipment__c = thisCase.Equipment__c;
            createCase.Date_Due__c = date.today() + days; 
            caseList.add(createCase);
        }
    }
    insert caseList;
}

}

Answer 1

If maintenance cycle is an integer field then you can simply use it as.

Integer days = [Select Maintenance_Cycle__c from Product2 where id =:thisCase.Equipment__c].Maintenance_Cycle__c;

You may need to cast it to an integer to take the integer value if it is a decimal using Integer valueOf().

The code assumes that query will always return something, based on your data model, additional checks can be added if the query fails.