Hi all,
Does anyone have a suggested SQL query that would determine the location of the current profie picture of a given user?
I'm using Confluence 3.5.7
Thanks,
Daniel
Community moderators have prevented the ability to post new answers.
The following query should do the job (replace "yourusername" with the username):
SELECT string_val FROM os_propertyentry WHERE entity_key = "confluence.user.profile.picture" AND entity_name = "CWD_yourusername"
This returns the attachment title of the profile picture if the user has a custom pic, or the path to a default avatar in Confluence. The attachment data is either in the attachment folder on the file system or in the table ATTACHMENTDATA.
Cheers
Remo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.