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.
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' )
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.