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?