I have a list of Epic IDs that I want to search for, how do I search for them?

[Adam Reusche]

I have a list of epic IDs in the following format:

XLPT-12

XLPT-13

XLPT-14

.....

and so on until about 500. I have all of them listed on a smartsheet. I want to be able to take my entire list, plug it into the search, and then bulk assign the issues to a specific reporter.

What's the correct advanced search syntax to get this to work?

[Adam Reusche · Accepted solution]

Love it when I figure it out on my own! So yes, from the other searches, you want to use "issuekey in ("XLPT-12","XLPT-13", ....).

Since I had this all in a smartsheet listed vertically, I copied all of my 500 IDs into Excel. I selected the entire column of IDs, copied them, and then transposed pasted the data horizontally. 

I then copied the horizontal data into a single cell. Doing a find and replace, I was then able to replace the spaces between IDs with ",". 

Copy all of the issuekey IDs into the advanced search and BAM!

They all appear.