Table filter in Confluence for JIRA labels

Shantharam

Hello, I have a hierarchy of labels to the defects we create in JIRA, something like following:

1. Main project
   1. Module of a main project
   2. Module 2 of a main project
      1. Submodule 1 of module 2 of a main project
2. Another main project
   1. Module 1 of another main project
   2. Module 2 of another main project

Let's say that we have a defect for the submodule, in that case I am adding the following as the labels: main-project-name, module-name, sub-module-name.

 

Now I have a requirement of getting all these tickets on to a Confluence page, organize the defects according to their belonging.

I am currently thinking to add a JQL Table macro with query to fetch main project labels (please see that it also fetches all modules and submodules). And I want to add table filter macro in such a way that, user must have the ability to filter by main project, AND module, AND also sub module. 

I am finding it difficult to achieve this using filters. Is there any other macro that can help me get this bifurcation? 

Stiltsoft support

Hi @Shantharam ,

I get it so that your labels coming from the Jira Issues macro are placed in the same table cell.

So, you get not

|main-project-name| module-name |sub-module-name |

but

|main-project-name, module-name, sub-module-name |

In such cases you may use a dropdown filter with AND/OR operators.

Please check this Community thread (the answer with screenshots given by @Katerina Rudkovskaya _Stiltsoft_ ). You'll see what is the difference between the AND and OR operators, how to set the cell value delimiter and how to use reversed filters).

Seems it may help your case.