Page Comparison

...

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. Click any of the hyperlinks to navigate to the respective user profile page to view the user deatils.