Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How to search JIRA label contents in Table Transform Confluence

Jan Marte Bacayo
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 13, 2024

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.

2 answers

3 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 14, 2024

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"

0 votes
Marc Koppelaar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 14, 2024

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.

 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events