Take the 2-minute tour ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.

I have two objects with Master-Detail relationship between them where Phase is Master Object and Phase Entity is Child object.I am trying to compare the data(field values) in eclipse.But I am getting an error Bind variables only allowed in apex code.

How to compare data(field values) between master and child objects?

Select e.Fund__c, e.Phase__r.Fund__c, e.Phase__c From  Phase_Entity__c e where e.Phase__r.Fund__c != e.Fund__c
share|improve this question

1 Answer 1

up vote 7 down vote accepted

SOQL won't let you compare fields within a query. You'll need to make a checkbox formula field on Phase_Entity__c.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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