Use case

You need to group Jira linked issues by types and preserve clickable links 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
FIRST(T1.'Linked Issues'->split("-")->0) AS 'Type',
FORMATWIKI(SUM("[" + T1.'Linked Issues' +
"|https://jsd.stiltsoft.com/browse/" + T1.'Linked Issues' + "]\\ ")) AS 'Issues'
FROM T1
GROUP BY 
T1.'Linked Issues'->split("-")->0

  6. Click Next. 

  7. Define the date format .

  8. Save the macro and the page.


  • No labels