Trying to copy excel issuekey to search in JIRA

latt11b

We are exporting JIRA issues into excel, then after using filters attempting to copy the issuekey columns and paste into a JIRA search but the format is incorrect.

 

Does anyone have a better solution?

 

Right now i have to paste in word and add comma's to every jira number space them correctly and then paste into the jira search.

Charlie Misonne

You will definitely need commas if you want to run a search like key in (ISSUE-1, ISSUE-2, ISSUE-9)

Perhaps you could improve your excel sheet by adding af formula that concatenates all issue keys and adds commas in between. Something like:

=LEFT(CONCAT(A1:A5&",");LEN(CONCAT(A1:A5&","))-1)