Save error: Initial term of field expression must be a concrete SObject: LIST<EventRelation>

Question

ayudad need. I want to create a batch class to update values ​​from another object. this is my code but it is giving me this error

anyone can help? Thanks.

This is the start and execute section.

global Database.Querylocator start(Database.BatchableContext bc){
    return Database.getQueryLocator([SELECT ID, Comentarios_Invitados__c,EventRelationId__c,Estado_Invitado__c,fecha_del_evento__c FROM Informe_icex__c where fecha_del_evento__c>=LAST_N_DAYS:1]);
}

global void execute(Database.BatchableContext BC, List<sObject> scope) {
    // Create a map for the chunk of records passed into method.
    Map<ID, Informe_icex__c> iMap = new Map<ID, Informe_icex__c>((List<Informe_icex__c>)scope); 

    List<EventRelation> eRList = [SELECT Id,response,status FROM EventRelation WHERE Id IN :iMap.keySet()];

    for(Informe_icex__c i : jobMap.values()) {
        if(!eRList.isEmpty()) {
            i.Comentarios_Invitados__c = eRList.response;
            i.Estado_Invitado__c = eRList.status;
        }
    }
    update iMap;
}

Answer 1

eRList is a list of 0 to many objects. i.Comentarios_Invitados__c is a single field. You can't fit a list into a field.

Where you have

i.Comentarios_Invitados__c = eRList.response;

Should look more like

i.Comentarios_Invitados__c = eRList[0].response;

Although I think your looping logic is a bit confused! But that attempted assignment of a List into a field which can hold only a single sObject reference is the reason for the error message you see.

Answer 2

You are attempting to access a list as if it is an sObject, you need to iterate over the list to first access the sObjects.

From your example it's a bit hard to understand what you are trying to achieve, so you may have to figure out the rest yourself.

Also, you can't give the update statement a map. You can however just call values() which returns the list of values from a map.

update iMap.values();