It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Auto editing user details by groups

Florian Loers Nov 20, 2013

Is it possible to auto-fill the details of users (Position, Department...) by their assigned groups? Or to set them automatically depending on their groups when they get created?

1 answer

0 votes
Ryan Goodwin Nov 20, 2013

It would be possible by querying the database directly. The user profile details are stored in the os_propertyentry table under entity_key columns:


Each of those records will have a value for entity_id which relates to the content table contentid field:


You'll see this record is for a content.contenttype = userinfo type page.

Now the trick here is that the os_propertyentry records do not exist until you add those properties for a given user. So you would need to add that information for each user that is a member of a group.

Groups are stored in cwd_group, memberships are stored in cwd_membership, and users are in cwd_user. You'd need to join the sql statements for those tables to get appropriate memberships.

I believe the userinfo record in the content table is created when the user is created in the database. This would be on ldap sync or first login depending on the user directory type.

Hope this helps!

Florian Loers Nov 26, 2013

First of all thank you for answering,

unfortunately I didn t know that our accounts are linked form the active directory and editing these fields is disabled in confluence :/ . So the best (only?!) way for solving my problem is to maintenance the data in the AD. I have already herad there is an issue for sharing more information between AD and confluence but I could not find it. Is it already possible?

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

6 Awesome Ways to Apply Trello, JIRA and Confluence to your Project

I attended  Atlassian Summit 2019  and learned a lot from the presenters, attendees and knowledgeable Atlassian product managers. The presentations I attended focused on applying Agile, pla...

1,294 views 8 19
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you