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

Multiple Issue Key search

Is it possible to search for multiple issue key and display all of them at once in my issue navigator? The issues don't have anything in commun ... no filter option.

3 answers

1 accepted

4 votes
Answer accepted

Select Issues/Search for Issues from the menu. Then select the advanced search. In the textarea then type what Jobin showed you. The quick search only works for a single issue key as far as I can tell. It is definitely annoying.

Works like a charm! (with advanced search)

Thank you!

Try like this:

key in (TEST-1, TEST-2)

Not working, I'm still getting much more result than what I'm looking for :(

Maybe I misunderstood, you are trying to show only selected issues in the issue navigator, right? If so, you just need to give those issue keys in the search. Are you saying you are getting issues which are not in this list if you give like this?

You understood right ... I'm entering (for the example) 2 issue keys (Test-1, Test-2) in the quick search field and I'm receiving a lot more than just the two entries.

Can you please attach a screenshot?

Try to use double quotes as well but the other one also woks for me!

key in ("TEST-1","TEST-2")

Like Matt Campion likes this

What if you want to search a range of keys. For instance, I want to search for issues 400 to 600 in a particular project.

Steven Behnke Community Leader Dec 15, 2014

Same here, I want a range of keys

Steven Behnke Community Leader Dec 15, 2014

It seems I can search key > KEY-1234 works fine

Like # people like this

I know, it isn't Christmas, but it was nice if I could search by the actual Number only, in the current project, without the need to "fully qualify" the issueKey, such as "Issuekey in (10,12,16)", instead of "Issuekey in (TEST-10, TEST-12,TEST-16)".

Or is this possible anyway and I'm overlooking something...?

BR,

Daniel

You try in advanced search like issueKey in ("TEST-1","TEST-2","TEST-3"). I was able to nail it.

Like # people like this

Thanks @Nithin Balachandran. Worked like a charm. Didn't even need the quotes around each issue key =-)

@Marcus BergmanThanks buddy keep charming !!

Sorry to bump but here's my challenge. I'm having a hard time to figure out how to exclude an issueKey list from my search;

project = PROJECTNAME AND issuetype = Test AND status in (Done, TODO) AND text ~ "string" AND (issuekey != 'PROJECTNAME-issueKeynum') ORDER BY status DESC, created DESC

So this query is working properly. It will exclude from my search the PROJECTNAME-issueKeynum, however, I have multiple issueKey to exclude. So I tried;

(issuekey != 'PROJECTNAME-issueKeynum1','PROJECTNAME-issueKeynum2')

no luck. I tried with double quotes, with "not in" operator instead of !=, searched online but hey, I'm pretty new to SQL or JQL should I say. Thanks in advance for the help.

would this work for you?

issuekey not in( key1, key2)

 

BR,

Daniel

Like Jean-Philippe Begin likes this

I've learned something today;

project = PROJECTNAME AND issuetype = Test AND status in (Done, TODO) AND text ~ "string" AND (key !=('PROJECTNAME-issueKeynum1','PROJECTNAME-issueKeynum2')) ORDER BY status DESC, created DESC

...will output:

Operator '!=' does not support the list value '("PROJECTNAME-issueKeynum1", "PROJECTNAME-issueKeynum2")' for field 'key'. 

Given that;

project = PROJECTNAME AND issuetype = Test AND status in (Done, TODO) AND text ~ "string" AND issuekey not in ('PROJECTNAME-issueKeynum1','PROJECTNAME-issueKeynum2') ORDER BY status DESC, created DESC

...will work. Why !? Cause the != operator doesn't support list value as it's said above. "not in" will. Pretty well explained here: Advanced searching - operators reference

Thanks for that amazingly fast help @Daniel Balogh

Well, I've learned something today;

project = PROJECTNAME AND issuetype = Test AND status in (Done, TODO) AND text ~ "string" AND (key !=('PROJECTNAME-issueKeynum1','PROJECTNAME-issueKeynum2')) ORDER BY status DESC, created DESC

...will output:

Operator '!=' does not support the list value '("PROJECTNAME-issueKeynum1", "PROJECTNAME-issueKeynum2")' for field 'key'.

Given that;

project = PROJECTNAME AND issuetype = Test AND status in (Done, TODO) AND text ~ "string" AND issuekey not in ('PROJECTNAME-issueKeynum1','PROJECTNAME-issueKeynum2') ORDER BY status DESC, created DESC

...will work. Why !? Cause the != operator doesn't support list value as it's said above. "not in" will. Pretty well explained here: Advanced searching - operators reference

Thanks for that amazingly fast help @Daniel Balogh

Glad could help :)

@Nithin Balachandran The provided solution works :)

For a Range of Issues as Steven Behmke mentioned a Range via Greater than and Less than works.

For me Key > {ProjectName}-34 and Key < {Projectname}-49 worked. Make sure no spaces.

This worked well for my "Key in (XXX, XXX, XXX)"

Thanks.

If one has list of issue keys and needs to search multiple issue keys then simply enter below given query in advanced search. 

Syntax: issueKey in (TEST-1,TEST-2,TEST-3)

Note: Please replace 'TEST-1,TEST-2,TEST-3' with your issuey keys.

Example: issueKey in (CASE-2457, CASE-1097, CASE-3292)

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

365 views 1 3
Join discussion

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