Export filters to Excel

[srinath]

I would like to export 100 filters to excel along with the filter name and JQL query. 

[mschonarthatlassian · Accepted solution]

Hello, Srinath

I understood from your request that you want to get all filters with their name and JQL query.

Do you also want to get all the filter results? Please, let me know so I can further assist you. 

There is no direct way through the user interface to export the details in the way you’re looking for.

However you can get all the filters for the current user using REST API.

GET /rest/api/2/filter will return all filters with detailed information.

You can also get the filter information based on filter id by:

GET /rest/api/2/filter/{id}

Hence there’s the possibility to write a script through REST to get the filters for many Ids specified on a list.

If you want more information about REST API I’d recommend checking out our documentation under Filter.

Please, feel free to ask if you have further questions.

Cheers!

[srinath]

Thanks for the information it was helpful.

[Aron Gombas _Midori_]

You may want to make the REST calls and insert the return values into an XLSX file using the Better Excel Plugin.

This is a use case that perfectly fits that app, and it even has recipes for REST that you can easily rework.