is there a way to create a filter with keys ending in odd numbers?

[Ricardo Martinez]

Hi

I need a filter that will allow me to get the issues that have a Key ending with odd number and another filter with even number.

How could I achieve this in the jql filter?

Thanks in advance

[Jack Brickey]

There is nothing in JQL that would allow for this. What is the use case here? Maybe there is some alternative solution. If I understood your used case, I might be able to offer such an alternative.

[Jack Brickey]

I guess you could export this to excel and deal with it there.

[Hannes Obweger - JXL for Jira]

Hi @Ricardo Martinez

if you're open to solutions from the Atlassian Marketplace, this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting - as well as the ability to filter issues via regular expressions. 

With regular-expression-based filtering, you can apply pretty much any logic, including the one that you are after:

The regex that I'm using is

[13579]$

which matches any string that ends with an uneven digit.

[02468]$

would be the regex for all even issue keys.

Once you've identified your issues, you can work on them directly in JXL (e.g., bulk edit them via copy/paste), or trigger various operations in Jira.

Any questions just let me know,

Best,

Hannes

[Revathi Segu]

There is no direct way to filter these issues using JQL filters.

• Instead try to get the numeric portion(ABC- 234) of the issue key value through Script and validate whether it (234) is even/odd and add the issue data to an excel/ list if that is odd/even respectively. 
• Also try to create a custom field with numeric value from the issue-key and validate the same.
  
  

Any of the above two solutions might resolve the issue.