Apex Code Development You need to sign in to do that
Don't have an account?
Error finding Tasks related to Opportunities with CreatedDate Range: No such column on Entity 'Name'?
Select Id FROM Task where What.RecordType.SObjectType='Opportunity' and (What.CreatedDate >2015-05-23T11:59:59Z and What.CreatedDate <2015-05-25T00:00:00Z)That is the query I am using. It seems fairly straightforward to me that only related entities of type Opportunity should be returned.
However, both DataLoader and DeveloperConsole return this error:
What.CreatedDate>2015-05-23T:11:59:59Z
^
ERROR at Row:3:Column:2
No such column 'CreatedDate' on entity 'Name'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name...."
Where am I goofing up?
THANK YOU!
where whatid IN (select Id From Opportunity where
CreatedDate >2015-05-23T11:59:59Z and CreatedDate <2015-05-25T00:00:00Z)
Please try this if you are trying to retrieve task with opportunity createdDate range
All Answers
where whatid IN (select Id From Opportunity where
CreatedDate >2015-05-23T11:59:59Z and CreatedDate <2015-05-25T00:00:00Z)
Please try this if you are trying to retrieve task with opportunity createdDate range
Do you know the reason why the first query doesn't work? (I come from an RDBMS background, which I've found hurts as much as it helps in the SFDC world)