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

[Giulyanna Loureiro]

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.

[John Funk · Accepted solution]

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)

[Giulyanna Loureiro]

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]

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

[Giulyanna Loureiro]

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]

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. 

[Giulyanna Loureiro]

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.