Partial match project category

[John Pisani]

I'm retrospectively adding project categories to projects in line with organisation structure. 

Project Category Examples

IT                         (department level) 

IT-ES                    (section level) 

IT-ES-SAS            (team level) 

JQL Example

Looking for a quick way to report across the board, so I was hoping to be able to do a partially match category to return issues belonging to projects categorised as IT-ES or IT-ES-SAS

category ~ "IT-ES*" 

The operator '~' is not supported by the 'category' field.

Do I need to (can I) copy this value into a custom field of an appropriate type, make that field available globally and query on that?

[Mohamed Benziane]

Hi @John Pisani

Did you try "catagory=" or "category in" ? Or it won't suit your board ?

Regards

[John Pisani]

Hi, 

I should have mentioned I was planning to go with that option for my immediate need.

i.e. Reporting for my group of teams IT-ES* for which there are a finite number of sub-categories.

category IN (IT-ES-A, IT-ES-B, IT-ES-C)

My ability to roll this approach further across the organisation would be limited though, so I was looking for something more dynamic.