How to search JIRA label contents in Table Transform Confluence

Question

I have lots of labels from JIRA loaded into table transform in confluence, is there a way for me to search specific characters like ABC123 in that section and repopulate it into a different column name?

Sample problem

CASE

WHEN T1.'Labels' contains ('ABC123') AS 'Letters'

I tried using CASE WHEN T1.'Labels' LIKE but it's not accurate enough, I need something that uses contains functionality.

Marc -Devoteam- · Accepted Answer

Hi @Jan Marte Bacayo

Welcome to the community.

To my knowledge of the app, this might be possible, see

https://community.atlassian.com/t5/Confluence-discussions/Transform-Jira-issue-table-with-Table-Transformer/td-p/2563685

This is not about labels but relates to it.

I suggest to reach out to Stiltstoft support, to make sure this is possible or not.

Stiltsoft support · Accepted Answer

Hi @Jan Marte Bacayo ,

Please check this part of our documentation regarding the LIKE function: https://docs.stiltsoft.com/tfac/cloud/custom-transformation-use-cases-with-advanced-sql-queries-42241587.html#CustomTransformationusecaseswithadvancedSQLqueries-Searchingforaspecifiedpatterninacolumn

LIKE "%a%" - Finds any values that contain "a"
LIKE "a%" - Finds any values that start with "a"
LIKE "%a" - Finds any values that end with "a"
LIKE "_r%" - Finds any values that have "r" in the second position
LIKE "a_%" - Finds any values that start with "a" and are at least 2 characters in length
LIKE "a__%" - Finds any values that start with "a" and are at least 3 characters in length
LIKE "B%s" - Finds any values that start with "B" and ends with "s"