To identify same category of Labels

Question

Dear All,

I have a scenario where i need to find the JIRA Tickets having more than one Labels of the same category (not duplicates .. but of same category as explained below) ..

i have a JIRA Table of 100+ tkts

Scenario:

- check the JIRA Tickets having more than one 'Testing' Labels

(we have many labels like 'Testing-abc', 'Testing-ert', 'Testing-uyi' , 'Testing-456' ... etc .. )

SO,

if any JIRA Ticket has more than one  'Testing' label

(for example, a tkt having Testing-abc and Testing-ert ..both .. )

THEN, i need to display those Tickets as 'Multi Testing Label' ones ..

im trying a code in my Confluence Table Transformer as

//// CASE

When T1.'Labels' LIKE "%Testing%" AND T1.'Labels' LIKE "%Testing%" AND T1.'Labels'             LIKE "%Testing%" Then "Multiple Testing Labels"

END AS 'Multi Testing Label'   ////

but this is not working ..

hence, reaching out to you .. please help ..

Stiltsoft support · Answer

Hi @Ramu ,

Seems that this question is a duplicate of the https://community.atlassian.com/forums/Confluence-questions/Multiple-fields-check/qaq-p/3015650 where you have a thread with @Daniel Berežnoi [for anyone who comes across this question].

Ramu_kd54ib · Answer

Hey

My requirement is mix of JIRA & Confluence ..

I have the JIRA Table and queries to be tweaked on Confluence Table Transformation (as this cant be directly done in JQL .. if you read my ask) ..

Hence, the request for Confluence Transformation logic ..

Tinker Fadoua · Answer

@Ramu

* Did you try JQL in Jira?
* Why are trying in Confluence?

Best,

Fadoua