I have a table-data of user full names and their email addresses. I use the column of email addresses to generate a list-data in a scaffold form. Is there a way to use the email address I have and retrieve the user's full name from Confluence?
Hi Kathryn Moye,
Happy New Year!
The answer is yes. All user is stored in Confluence CWD_USER table. Here the query to list their display name and email. Replace the <EMAIL> in the query with your user email.
select DISPLAY_NAME from CWD_USER where EMAIL_ADDRESS=<EMAIL>;
Hope this help!
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG