You need to sign in to do that
Don't have an account?
SunnyShiny
What would be the query to export owner of contact linked to an event
Hi
first of all thanks for your help .. im new on soql and lost after sql server.
If there is any table showing difference between sql and soql Im interested
So I ve got a list of users and I need a list of event with the id of the contact assigned to and the owner of this contact.
I've got not clue how to do that in soql and I need to export this through data loader.
SELECT Subject, OwnerId, Owner.Name, whoID, who.ownerID
FROM Event
WHERE ownerID in ('00Ua002500LIKza','00Ua002500jDKza','00Ua002500AaKzc')
Thanks a lot for your help
Looks like a job for Polymorphic SOQL Queries!! <soundEffects />
This works great on API 27.
You can test it by logging in to the workbench and selecting SOQL tools.
https://workbench.developerforce.com/
Select id, ownerid, TypeOf Who when contact then name, ownerId end From Event
Here's more info on Polymorphic queries.
http://www.salesforce.com/us/developer/docs/dbcom_soql_sosl/index_Left.htm#StartTopic=Content/sforce_api_calls_soql_relationships.htm#relates_and_polymorph_keys
I've got this error >
MALFORMED_QUERY: SOQL TYPEOF expressions are not supported in this organization
Select id, ownerid, TypeOf Who when contact then name, ownerId end From Event
Is there an easy way to manage this without workbench through force.ide?
How can I make the relation ??? easily
is the fastest way by exporting event and contact and through excel doing a vlookup?
thanks