Exporting ownerID information into CSV file

Data Service
1

I need to export information about who owns the record into a CSV file. Here’s what I’ve got going…

image
image1058×725 53.9 KB

The problem is the last one circled in red. ownerID doesn’t behave like a regular relation. Which makes sense to me. But, how DO I access that information to export it? Or is this something I need to add to the record in columns at the time it’s created?

Thanks!

2

ownerId is object ID field - not an object itself.
It does not have name property (or any property at all)

You should query for name field in contacts table using ownerId in where clause

3

Thanks! I’ll probably just store the information in the record when it is built for simplicity. It’s referred to often.