How do you search multiple tickets with issue keys?

Pat Casil July 12, 2015

Im currently using JIRA cloud and i need to bulk update statuses of tickets.  i have a list of the issue keys (ticket#) on a spreadsheet.  What syntex would i use to pull up all the tickets? I'm trying the following and it doesn't work.

issuekey in ("test-1, test-2, test-3")

I can pull up one ticket by using the issuekey in ("test-1")

4 answers

1 accepted

1 vote
Answer accepted
All-In-One Support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 12, 2015

try issuekey in ("test-1", "test-2", "test-3")

Deepa Tantry August 29, 2018

Hi 

I have 500 issues in my project and if i have to display the list of issues from key-250 to key-300. How do i do that?

 

Appreciate any help.

 

Thanks

John Cliff Le December 7, 2018

Hi Deepa,

Were you able to find how to do this approximate search? I want to know as well.

Thanks,

John

John Cliff Le December 7, 2018

I was able to do this: AND issuekey > dss-77 AND issuekey < dss-93.

2 votes
Shubham Karwa February 9, 2019

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 actual issuey keys.

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

0 votes
Frederick Trelfa July 15, 2020

Get rid of the quotes, and you should be fine:

issuekey in (Test-1, test-2, test-3) should work. 

0 votes
Pat Casil July 12, 2015

Perfect! thanks!

Suggest an answer

Log in or Sign up to answer