Apex Code Development You need to sign in to do that
Don't have an account?
SOQL Query FROM Event : How to get "Contact Title"
Hello,
I'm trying to get the Title of the contact in this query.
I know that events can be related to Leads or Contacts. That's probably what is causing this issue.
SELECT CreatedBy.Name,Account_Name__c,Who.Name,CreatedDate, Who.Title
FROM Event
WHERE CreatedBy.Profile.Name = 'Account Executives'
AND Meeting__c = TRUE
AND CreatedDate = today
Your help is much appreciated.
Nathan
I'm trying to get the Title of the contact in this query.
I know that events can be related to Leads or Contacts. That's probably what is causing this issue.
SELECT CreatedBy.Name,Account_Name__c,Who.Name,CreatedDate, Who.Title
FROM Event
WHERE CreatedBy.Profile.Name = 'Account Executives'
AND Meeting__c = TRUE
AND CreatedDate = today
Your help is much appreciated.
Nathan
Please try as mentioned below -
----
Thanks,
Srinivas
- Please mark as solution if your problem is resolved.
I use Force.com explorer and it says that '[' is an unexpected token
----
Thanks,
Srinivas
- Please mark as solution if your problem is resolved.