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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

I have a list of issues I want to look up (AB-01, AB-02, AB-03, etc). How do I search all together?

I have a list of issues I want to look up (AB-01, AB-02, AB-03, etc). How do I write the JQL so I can add my full list in the Advanced Search view?

E.g. I tried and it didn't work

project = AB AND issuekey in ( "AB-01, AB-02, AB-03,AB-04,AB-05,AB-06")

 

I just want to see this specific list in the Advanced Search view so I can export the status, assignee and other fields afterwards.

1 answer

1 accepted

1 vote
Answer accepted
John Funk Community Leader Dec 09, 2020

Hi Giulyanna - Welcome to the Atlassian Community!

Just use key instead of issueke - and no quotes in this case.

project = AB AND key in ( AB-01, AB-02, AB-03, AB-04, AB-05, AB-06)

Thanks a lot, Mr Funk, it worked!

However it changed the order I added them in so it takes me a while to sort. Any ideas on how to make it stick to the order I have in my brackets?

John Funk Community Leader Dec 09, 2020

project = AB AND key in ( AB-01, AB-02, AB-03, AB-04, AB-05, AB-06) ORDER by key

Apologies. Actually, my example should have been ( AB-04, AB-02, AB-01, AB-05, AB-03, AB-06) , it's in not in an order that I could use existing filter options but I would like to keep this order to use in my report.

Thank you!!

John Funk Community Leader Dec 10, 2020

Unfortunately, all sorting is done by alphabetical or numerical means. So you would need to use another field, such as a custom number field or text field where you have values like 1, 2, 3 or A, B, C, etc. attached to each issue. Then you could sort on the custom field. 

Thanks, John. I get a list of tickets from a stakeholder and need to report back in the priority order they send.

By searching:

project = AB AND key in (AB-04, AB-02, AB-01, AB-05, AB-03, AB-06)

I have it in a list format and can export, which is great, but for some reason it changes the order (even if I don't add any sorting).

Thank you very much for your time and help.

Like John Funk likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

7,120 views 8 28
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