Redmine

When the query filters by a custom field not set for all projects, turning it into a global one erases the field. This feature would allow sharing such queries across the projects who uses such custom fields.

Beyond sharing them like versions, it would be nice to list the projects where the query would work. However, this could become an administrative nightmare if one site has too many projects (mine have over 700!). Alternative: show global queries only where all filtered fields are available.

+1

Good comment about global queries dropping non-global fields.

The original intent of this request was to allow sharing like Versions, that is, Subprojects, Hierarchy, and Tree. (With the Subprojects@ and Hierarchy being the more useful ones.)

+1

+1

I think that allow sharing like Versions is best way,

As a method of simplifying implementation,
I think that queries defined in the top project may be displayed unconditionally.
In this way, you do not have to modify the Database.

By the way,
the function of category also has the same problem. I created a patch below.
http://www.redmine.org/issues/5358#note-98

I changed some code of Redmine and tried to create a countermeasure.

Considering the actual operation, I think there are the following two issues.

1.Use authority setting of custom query shared among PJ.
2. Create/ Edit shared amaong PJ Custom Query (except admin)

1.Use authority setting of custom query shared among PJ

This can be achieved by using role-based custom query access control, enabling all projects, and assigning a role to each project.
(This feature is introduced in Redmine 2.4.0, so there is no need to develop new features.)

2. Create/ Edit shared amaong PJ Custom Query (except admin)

Another issue is that only admin can create and edit custom queries shared among PJs.
I created a workaround patch for this issue by assigning the custom query create/edit privilige , the same all custom PJ target as admin to the custom query author.

Please refer to the following for details.
https://github.com/y503unavailable/redmine/issues/28

However, in principle, it is considered appropriate to set permissions in System level Role.

I am glad if it helps.

+1