JQL query to filter dropdown field values that contain text phrases

[James K_]

Hello,

I am looking to create a report that checks the number of tickets for unsupported versions of software.  When customer open tickets, I have a field with a list of our released versions (example "2.0", "2.1", "3.0", etc.) , and when support for that version ends we restrict the availability of the old fields and have options that include "(Unsupported)" (ex. "1.0 (Unsupported)", "1.1 (Unsupported)").  I've tried to write a JQL query as
[field name] ~ "Unsupported" or alternatively [field name] !~ "Unsupported", but I'm getting a message that "The operator '~' is not supported by the 'field name[Dropdown]' field."

Thanks!

[Gabriel Senna]

Hi Gary,

I recommend you to try the Tempo Timesheets add-on for JIRA.

It gives you a lot of options and feature to control and manage the work log.

https://marketplace.atlassian.com/plugins/is.origo.jira.tempo-plugin/cloud/overview

You can try the free trial to confirm if it helps you.