Database table for User Details

Joshua Smith_m9cfyk

Hello

I have a query that pulls the list of users from the Postgresql database, which I use to check on the users in our wiki that are clients. However, to improve this query I would like to pull the Department field, which is set under Edit Details in the user setup. However, I have been unable to find the table that this information is stored in.

 

Any help appreciated.

Joshua Smith_m9cfyk

Nevermind, I worked it out

 

( SELECT OS_PROPERTYENTRY.string_val, CONTENT.USERNAME FROM OS_PROPERTYENTRY INNER JOIN CONTENT ON OS_PROPERTYENTRY.entity_id=CONTENT.CONTENTID AND OS_PROPERTYENTRY.entity_key='confluence.user.profile.department' )