0

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 ?

0

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.

  • I get another error: expecting a colon, found 'Poste__r.Date_dernier_bilan__c', so i think the colon is required – Merabti iBRAHIM May 20 '16 at 9:26
  • 1
    You can't do it like that, you can use only apex variables for such comparison or create another sub-select but it won't work as it support only Id fields. So the only way is first get those dates in apex variable and then do a select. – Oles Malkov May 20 '16 at 9:29
  • @ Oles Malkov i will try that right away – Merabti iBRAHIM May 20 '16 at 9:32
  • @ Oles Malkov can't we write sub-query ?? – patelkiran3090 May 20 '16 at 9:33
  • at least the code get saved without errors this time, i will check if the results are as expected – Merabti iBRAHIM May 20 '16 at 9:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.