You need to sign in to do that
Don't have an account?
SunnyShiny
SOQL how to query even owner name
Hello,
I tried
SELECT e.Subject, e.OwnerId, (select Name from User where id=e.OwnerId) FROM Event e where subject = 'TEST'
but it doesn't work
If I run this query below >
SELECT Subject, OwnerId, Owner.Name FROM Event where subject = 'TEST'
The Name column will show Name value as vlookup and by clicking on it I can see the name.
What if I want to see directly in my query the value, the name of the user.
Thanks
Your query is right, the UI you get is an aspect of the tool you're using, not the query.
Thanks for the quick answer but there is no way to have the name of the owner instead of this lookup clickable value "name"
?
Thanks
Use a different tool, soqlx works well for this.