Creating clickable links to the Jira issues

Use Case

You need to count the number of issues by status and make reference to JIRA.

Solution

1. Switch the page to the edit mode.

2. Insert the Table Transformer macro and paste the table or the macros outputting tables within the macro body.

3. Select the macro and click Edit.

4. In the Presets tab select Custom transformation and click Next.

5. Enter the following SQL query:

   SELECT 'Status',
    FORMATWIKI("["+ COUNT(*) +"|" + 
   		   "https://jira.stiltsoft.com/issues/?jql=issuekey%20in%20(" + 
   		   ARRAY(T1.'Key') + ")" + "]")
   AS 'COUNT'
   FROM T1 GROUP BY T1.'Status'
   UNION ALL CORRESPONDING
   SELECT "Total" AS 'Status',
   FORMATWIKI("["+ COUNT(*) +"|" + 
   		   "https://jira.stiltsoft.com/issues/?jql=issuekey%20in%20(" + 
   		   ARRAY(T1.'Key') + ")" + "]") AS 'COUNT'
   FROM T1

   SQL

6. Click Next. 

7. Define the date format .

8. Save the macro and the page.