How to find Filter Name from Filter ID ?

[Tatiana Jancusova]

As a JIRA administrator I found some warning according some filters in the log files. So I have now the filters IDs. I would like to know the names and the owners of those filters.

If I am using the https://example/issues/?filter=id

I get the message:
The requested filter doesn't exist or is private.

If I am using the SQL:
select *
from searchrequest
where id = id

I get empty table.

My question is, if the filter is private, would I see it in the SQL table? How can I find the Filter Name and owner?

[Nic Brough -Adaptavist- · Accepted solution]

The filters don't exist, that's probably what the warnings are.

Could you tell us what the warnings actually are?

[Tatiana Jancusova]

There are from the structure add on. The filter, that are used for the synchronization does not exist or is not available:

2017-12-20 07:47:36,904 Structure-Jobs-3d61a76 Queue-Thread#7486 : Filter autosync #423 for structure 'TMS FD' (#405) WARN samuel.ramos<-samuel.ramos [clter.FilterSynchronizer] failed to run: filter 22856 does not exist or is not available to samuel.ramos

I wanted to find out if it does not exist or is just not available for the user and me. 

[Nic Brough -Adaptavist-]

They don't exist.  The database query tells us that.

You'll need to amend the Structures you've got set up so that they reference existing filters, or remove the Structure.

[Ignacio Pulgar]

If the SQL sentence you've executed does not return the filter row, then it doesn't exist.

Executing this SQL sentence can give you some additional understanding on how filter shares are managed in the database:

SELECT sp.entityid, sp.sharetype, sp.PARAM1, s.filtername, s.authorname 
FROM searchrequest s, sharepermissions sp 
WHERE sp.entityid = s.ID
  AND sp.entitytype = 'SearchRequest'
  AND sp.sharetype != 'global'

[Paul A Wright]

I have to disagree with the responses, suggesting the filter doesn't exist.  It could be as simple as a permissions issue.
I just encountered this and couldn't understand why a filter I was trying to view displayed such a message. If it was one, I'd think perhaps it didn't exist and move on, but there were multiple filters.
I SU'd as another user to see what they saw and they could see the filters.
I granted myself permissions (as I'm an admin) and can now see the filters that were previously 'non existent'.

[Nic Brough -Adaptavist-]

I'm afraid you probably misunderstood - the question was about looking in the database for the filters.

The database does not have any permissions on it, there's no way to hide anything from a user of the database.

This is nothing to do with permissions on the filters.  The filters are not in the database, therefore they do not exist at all.

[Paul A Wright]

Ah, apologies.  Thank you for clarifying.  Happy for the comment to be removed if appropriate.