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?
Thanks
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!
Regards,
Jing Hwa
Happy New Year to you!
Our admins won't give us access to the SQL macro. Is there any other way?
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.