Apex Code Development You need to sign in to do that
Don't have an account?
vijayn ASF queries with relationships in query
Hi all,
Is using relationships in SOQL supported in ASF?
I am trying something like this and ASF seems to be stripping out the relationship name.
@list = MyCustomObject.find(:all, :conditions => ["MyCustomRelationship__r.Name = 'foo'"])
Note:
SELECT Id, owner.Name, Name, Title__c, Description__c FROM MyCustomObject__c WHERE (MyCustomRelationship__r.Name = 'foo') works, but the above results in:
SELECT Id, owner.Name, Name, Title__c, Description__c FROM MyCustomObject__c WHERE (Name = 'foo')
If not, is there a way to do this? does ASF support :join?
Vijay
Message Edited by vijayn on 12-09-2008 11:32 AM
Is using relationships in SOQL supported in ASF?
I am trying something like this and ASF seems to be stripping out the relationship name.
@list = MyCustomObject.find(:all, :conditions => ["MyCustomRelationship__r.Name = 'foo'"])
Note:
SELECT Id, owner.Name, Name, Title__c, Description__c FROM MyCustomObject__c WHERE (MyCustomRelationship__r.Name = 'foo') works, but the above results in:
SELECT Id, owner.Name, Name, Title__c, Description__c FROM MyCustomObject__c WHERE (Name = 'foo')
If not, is there a way to do this? does ASF support :join?
Vijay
Message Edited by vijayn on 12-09-2008 11:32 AM