This article explains how to convert results generated by the SQL for Confluence app into hyperlinks that navigate you to required pages.
Instructions
Consider an example where you are fetching a list of users from MySql database.
Fetch the list of users from the database using the following SQL query.
select user_name from cwd_users;
To convert the result to a clickable hyperlink, use the SQL CONCAT function in a SQL query and make output format as wiki in the SQL macro.
select CONCAT('[',user_name,'|serverURL/confluence/admin/users/viewuser.action?username=',user_name,']') as user_name from cwd_user;
The above query adds user profile links as hyperlinks to the users list as shown in:
- If you click on any of the hyperlinks in the above table it will redirect to that specific user profile page as shown in: