Page Comparison

This article explains how to use the CONCAT, JOIN, LEFT functions in MySQL using the app SQL for Confluence (Pro Edition).

Instructions

Follow the steps:

1. Log into the Confluence instance.

2. Go to the required confluence page and edit the same.

3. Add SQL macro and go to the Edit option to open the settings.
   Image Modified
   

4. Select the Data source profile and write the SQL statement as shown in the below image. Follow this link to configure Data source profile.
   
   a. CONCAT () - This function allows you to add two or more strings together.
   

   Code Block
   language sql
   SELECT user_name, CONCAT (display_name," ", active," ",created_date) AS Userdetails FROM cwd_user;

   
   Image Modified
    Click on Save settings and Update the page.
   Image RemovedImage Added
   
   b. JOIN - A JOIN clause is used to combine rows from two or more tables, based on a related column between them.
   
   In the below example, we have joined two tables cwd_user and cwd_group. Displayed the result based on both the tables.

   Code Block
   language sql
   SELECT user_name,last_name,group_name FROM cwd_user JOIN cwd_group on cwd_user.directory_id = cwd_group.directory_id;

   
   Image Modified
     Click on Save settings and Update the page.
   Image Modified
   c. LEFT () - This function is a string function that returns the left part of a string with a specified length. 
   
       In the below example, the following statement uses the LEFT function to return the 5 10 leftmost characters of the string group_name. The long group_name can be displayed in a short form if required.
   

   Code Block
   language sql
   SELECT group_name, LEFT(group_name, 510) summary FROM cwd_group;

   
   

   
   

5. Image RemovedImage Added
    Click on Save settings and Update the page.
   Image RemovedImage Added
   
   

...