Page Comparison

This article explains how to convert results generated by the SQL for Confluence app into hyperlinks that navigate you to required intended pages. 

Instructions

Consider an example where you are fetching a list of users from MySql database.

1.  Fetch the list of users from the database using the following SQL query. 

   Code Block
   theme Midnight
   select user_name from cwd_users;

   
   

2. 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.

   Code Block
   theme Midnight
   select CONCAT('[',user_name,'|serverURL/confluence/admin/users/viewuser.action?username=',user_name,']') as user_name from cwd_user;

   
   

3. The above query adds user profile links as hyperlinks to the users list as shown in:

   
   
4. If you click on Click any of the hyperlinks in the above table it will redirect to that specific user profile page as shown in:
   Image Removedto navigate to the respective user profile page to view the user deatils.
   
   Image Added