How do you search multiple tickets with issue keys?

[Pat Casil]

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")

[All-In-One Support · Accepted solution]

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

[Deepa Tantry]

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]

Hi Deepa,

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

Thanks,

John

[John Cliff Le]

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

[Shubham Karwa]

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)

[Frederick Trelfa]

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

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

[Pat Casil]

Perfect! thanks!