You need to sign in to do that
Don't have an account?
Vijay 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
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