+ Start a Discussion
SunnyShinySunnyShiny 

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

SuperfellSuperfell

Your query is right, the UI you get is an aspect of the tool you're using, not the query.

SunnyShinySunnyShiny

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

SuperfellSuperfell

Use a different tool, soqlx works well for this.