+ Start a Discussion
Christos KolonisChristos Kolonis 

Map variables through query


i want to get the value of the confList to the guaranteeSOQL but i get the error: Variable does not exist: Replaced_Configuration__r
how can i overcome this?
list<Configuration__c> confList = [select id, name, Basket__r.id, Basket__r.Account__r.id, Replaced_Configuration__r.id  from Configuration__c where Basket__r.id = : basketId];
Guarantee__c guaranteeSOQL = [select id, name, g_Configuration__r.id from Guarantee__c where g_Configuration__r.id =: confList.Replaced_Configuration__r.id];

Thank you.
It seems that relationship name is not Replaced_Configuration__r. Check the schema of your org.