Determine when a Jira saved filter was last executed

Question

Hello,

We're in the process of replacing a custom text field from Jira with a label field. However, we have several users with saved filters that reference the replaced field. We want to avoid having to update the database directly, but with over 2000 filters referencing the replaced field, it would be difficult to manually change them in the Jira UI.

Is there a way to determine from the database when a filter was last executed? This would help us narrow down the list to only actively utilized filters.

Thanks

unknown · Answer

Hi,

I'm also interested to know last execution date for a filter. Any idea how to get it?

Thanks

Ahmed

Andy Heinzer · Answer

To the best of my knowledge, the Jira database does not keep track of when any user might access a filter.  So I don't think that you will be able to look at the database to find inactive filters exactly.

You can try to follow the steps in the KB: How to Enable Detailed SQL Logging in JIRA although I don't think you'll need to do step #4 since we're not dealing with AO tables here.  But even when you follow these steps, and then access a filter in Jira, there are no update or insert into SQL commands that relate to users accessing this filter.   I tried this just to see if there was something I was missing, but I could not find any such SQL record that logs this access or usage.

Perhaps you could ask your Jira users to favorite all the filters that they use frequently, and also unfavorite any filters that they do not need/user anymore.   This way, if your users are responsive and reactive to this request, you can probably figure out which filters are most popular and still in use.  Then you could run a SQL query such as

SELECT * from searchrequest order by fav_count desc;

Which would order all the filters from most popular to least.