How is live_profile related to sys_user?

[Brian Bush]

Does anyone know how to find a user's live_profile sys_id using the sys_user record? It seems like there must be a relationship between these tables, but it isn't obvious. I can see a table_name field on the live_profile record that is set to sys_user. I assume there is a table somewhere that relates the sys_ids.

[Uncle Rob · Accepted solution]

It won't be obvious from the User record side of the equation because the reference exists on the live_profile record.

So a couple options...

1)   Search in the live profile table for a document id that matches your user's sys_id.   That should yield 1 live profile record you can get the sys_id from

2)   Build a custom relationship that matches document id to current user id.

[Brian Bush]

Exactly what I needed.

[shane_davis]

Robert,

        I know this was several months ago, but I am wondering if you can give me further information on how you accomplished this.   Thank you.

Shane

[Uncle Rob]

Shane,

I'm happy to help however I can.   However, I'm not sure I can state it more exactly than I already have.   Which part do you need further assistance on?

RDF