How to export just the issues keys of a search as a text list I can paste into a new search after IN

[Emiliano]

Hi,

Is it possible to export the results of a search (just de issues IDs as a text containing the list of issues keys the search has returned?

Example:

- If the first search returns the issues PRJ-1,PRJ-2,PRJ-3

- In the second search JQl I want to include key in (PRJ-1,PRJ-2,PRJ-3) without having to copy and paste manually the list of keys

Regards, Emiliano

[Payne · Accepted solution]

This isn't a good solution for doing this repeatedly, but if it's a one-time thing, you may consider exporting your results to CSV (doesn't matter which columns are included, as long as the key is one of them), open the file in Excel, and then in one of a couple of ways convert the column of keys to a comma-separated list:

* Add a column as follows: if your first key is in cell A1, in B1 (or whichever column you wish) enter =A1; in B2 enter =B1&","&A2 and copy that formula all the way down; the final cell in B will have your list.

* Or paste the column into a text editor, with one key per line. Then use search and replace with regular expressions activated and convert $\r\n or $\n to ,

Hope this helps,

Payne

[Emiliano]

Thanks Payne, 

I'll either use your first suggestion or write a small Python script to do the job on the exported .xls every time I needed.

[Brant Schroeder]

Emiliano,

  I believe that JQL Search Exstension allows for nested JQL queries and ScriptRunner has a linkedissuesof function for nested search.  Both are add-ons and would require you to purchase them to have a single query solution.  

There are related feature requests for your question in JAC so you can vote for them:

- JRASERVER-18918 (for Server)

- JRACLOUD-18918 (for Cloud)

[Emiliano]

Thanks Brant. The nested option wouldn't do it for me since there are some days/weeks between both searches and some issues might have been added to the sprint I'm doing the report on