error: Variable does not exist in soql [duplicate]

Question

here is the query i am using:

bilan1 = [select id,valider__c,poste__c,Statut__c,Poste__r.Date_dernier_bilan__c, date_bilan__c, moyenne_du_bilan__c from Bilan_de_positionnement__c where poste__c in: collID and date_bilan__c =:Poste__r.Date_dernier_bilan__c  order by date_bilan__c asc];

i get this error:

Variable does not exist: Poste__r.Date_dernier_bilan__c

when i remove the condition and date_bilan__c =:Poste__r.Date_dernier_bilan__c the error disappears even though the Poste__r.Date_dernier_bilan__cfield is fetched in the query meaning that the variable Poste__r.Date_dernier_bilan__c does exist, am i messing something ?

Answer 1

i think you don not need : match fields. : for variables. so query should be like :

bilan1 = [select id,valider__c,poste__c,Statut__c,Poste__r.Date_dernier_bilan__c, date_bilan__c, moyenne_du_bilan__c from Bilan_de_positionnement__c where poste__c in: collID and date_bilan__c = Poste__r.Date_dernier_bilan__c  order by date_bilan__c asc];

it might help you.