"project not in" filter fails with "value does not exist" error

Question

I use and share the following filter to list all issues for all project in a category, except 2 projects:

category = Hue and project not in (HIVV,HIVA)

(in fact, this is just part of the actual filter)

This works for users with access permission on the HIVV and HIVA projects. However, the filter fails for users with no access permission to HIVV or HIVA with a A value with ID '11610' does not exist for the field 'project' error, and it shows no results.

Since the results for those projects are excluded anyway, it is irrelevant whether the users has access or not.

The reason for using a category is to avoid having to add all project names to the filter. How should I configure the filter to make it work when users have no access to the projects that are excluded anyway?

J K_bd2e15 · Answer

I can't believe that all users who share a filter with project keys must have the same project rights.

Anthony France · Answer

Has any workaround or fix been identified for this issue as of yet?

Frank Schophuizen · Answer

You are right that I (who wrote the query filter) have access to those projects. So I had not trouble with it. But once I started sharing the filter by using it on a dashboard to make an overview of data of the remaining projects), people started complaining they could not drill down on the data because the query failed. Not all users have access to the excluded projects.
Reason for excluding those projects is to avoid that they would show up on the dashboard. And they don't, but it causes problems with drill down on the projects that do show on the dashboard.