Is it possible to extract data when filter was created in Jira?

[lpopek]

Hello devs, 
I want to remove old filters from Jira, so I want to retrive data  when certain filter in Jira was created, and for example remove filters created 5 years ago.  The best way that I prefer is to this via Script Console (Groovy) 

Thanks 

[Andy Heinzer]

At the present, this is not possible to do.  The reason being, Jira does not record the date or time when a filter was created within the database.  You can see this for yourself in the Jira database if you query the searchrequest table:

select * from searchrequest;

The only thing I can think of that might help here is the id field in that table.  When filters are created, they are done so in a sequence.  Typically the first filter created has an ID value of 10000.  And each subsequent filter created increments that value by 1.   So you might be able to use that value in the database when trying to figure out the order in which filters were created, but this doesn't tell you exactly when a filter was first saved in Jira.

[lpopek]

Thanks Andrew! Have a nice day!