+ Start a Discussion
Vijay RautVijay Raut 

SOQL - Relationship

Hi All,

We are having "Transform__c" field on User Object. We are having problem in Owner relationship in following queries.

Select count() from event e where e.Owner.Transform__c = 1

It gives error saying that
"No Such column 'Transform__c' on entity 'Owner'. If you are attempting to use custom field, be sure to append '__c' after the custom field name. Please reference your WSDL or describe call for appropriate names".

But we are having 'Transform__c' field on User (Owner) and following query is working fine.

Select count() from Account a where a.Owner.Transform__c = 1

I was just checking and this type of relationship query is working fine for Account, Contact, Opportunity,... etc object.
But i am getting error for above query when i am trying to get count for Task, Event, Lead,..etc

Does anyone come across such type of problem.

I am not sure what is different in Task, Event, Lead object compare to Account, Contact, Opportunity object

Thanks in advance.
V.R.


Message Edited by Vijay Raut on 09-25-2008 12:25 PM