how to backup/export JQL filters source

Question

I would like insight on how to backup/export JQL filter's 'source' - either with Jira or a 3rd party utility.  I currently have around 80 filters and would like to backup/export all of them so if a filter is changed or accidently deleted - I would have an easy way to restore just the affected filter.

Currently doing a manual copy/paste of each filter's source and name into a text file/excel is time consuming. Also IT cannot restore just the affected filters on a Jira system restore. Making a copy of each filter within Jira would not make our IT happy because would add alot more filters and there is no folder structure in the Jira filter interface to organize.

thanks for any insight,

Chris

Nic Brough -Adaptavist- · Answer

You will need to use one of the apps that helps with reporting or migrations, most of them can list out filters.

Or you can scrape them over the REST API.

Nic Brough -Adaptavist- · Answer

Not on Cloud you can't

Dennis Grochowski_uvc1yp · Answer

You can easily get all the required information through a simple database query.

Try this:

select ID,filtername, authorname, reqcontent from searchrequest where id not in (select entityid from sharepermissions where entitytype='SearchRequest');