Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Filter Issues by a number of item numbers? I can't get it to work somehow.

Hello all,

I think the solution is only possible with JQL, but unfortunately I haven't found a way yet and hope you can help me.

I have created a custom field "article number" and there are numerous issues for different item numbers.

For Example:
SharedScreenshot.jpg

I have a list of article numbers on my desktop (about 50 article numbers). I would like to filter the corresponding issues for the list of article numbers (i think can copy and paste them into a JQL formula).

Translated into simple words, my function would be:
Find me the matching issues from the project (project name) for the following item numbers (123456, 567893, 123532).

3 comments

Payne Community Leader Jul 15, 2021

This ought to work for your needs.

project = "My Project" and "Article number" in (123456, 567893, 123532)

Like # people like this
John Funk Community Leader Jul 15, 2021

Payne's solution should be what you need!

Thank you very much so far @Payne 

I forgot to mention that the custom field "article number" is a text field (single line). Then it doesn't work in this case, at least it didn't work. Do I have to change the field to "numeric"? But if I change the custom field from text field (single line) to numeric, I lose the leading zero, right? That doesn't help me. I know, I can't change the format, but I can create a new custom field and import the old data.

My idea so far:

project = "My Project" AND "Article number" ~ "655013"

But it does not yet work with different article numbers.

This one doesn't work:

project = "My Project" AND ("Article number" ~ 382020 AND "Article number" ~ 081577)

Another addition:
If an article number has a space between the numbers, there are also problems, aren't there? So sometimes an article number is not just "123456" its more like "023456 323".

Many thanks in advance

Payne Community Leader Jul 16, 2021

In that case you can do similar to what you provided, but use OR rather than AND (think of the logic; using AND means the article number must match all the values you provide, which is impossible for any given issue), and enclose your values in quotes to allow for embedded spaces, e.g.

project = "My Project" AND ("Article number" ~ "382020" OR "Article number" ~ "081577" OR "Article number" ~ "023456 323")

Like Seb likes this

Thanks for your input here. I hope this could be helpful for the OP. lOl!

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Trello

🏊‍♀️ Atlympic Event: Trello

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

87 views 0 8
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you