Feature #31349

Allowing non-admin to create/edit custom queries shared among projects

Added by Yuuki NARA over 1 year ago. Updated 6 months ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Issues filter
Target version:-
Resolution:

Description

In Redmine, creation and editing operations of custom queries shared among PJs are designed to be possible only by admin.
As of Redmine 3.4, 4.0

This can result in the following problems
Especially in large scale environments.

1.Work load concentration to admin

2.Increment of admin authority assigner

3.The creation / editing function of the inter-PJ shared custom query
is not actively used because the user does not complete the work.
It is a psychological barrier because you have to ask admin one by one

As a result, the same custom query is created individually for each PJ.
This leads to an increase in work load and work errors.

As this correspondence, I want to make non-administrator to create/edit the inter-PJ shared custom query.
Only custom query author can edit custom query.

I filled in the response method in the comment.

History

#1 Updated by Yuuki NARA over 1 year ago

Response method

I considered the following measures.
In the following plan, DB design change and addition of roles are unnecessary.
However, I think that system level user role setting is basically necessary.

1. Make it possible to create custom queries for all projects other than admin.
2. Users that can be created are limited to users who have the authority to create and save custom queries in the project.
3. Create only custom queries whose access is restricted by roles.
Being able to create unlimited custom queries leads to custom query SPAM.
In the case of specifying a role, it is considered to be within the allowable range because the project administrator has decided to use that role.
4. Make the author of the custom query editable the custom query for all PJs created by him / her.

The following prototype (3.4 based) has been created for 1, 2 and 4 above
https://github.com/y503unavailable/redmine/issues/28

#2 Updated by Yuuki NARA 6 months ago

Sorry,the following is for Japanese

プロジェクト間共用カスタムクエリをadmin以外が作成/編集可能にする
https://qiita.com/y503Unavailable/items/2721608ef372f422b5d0

Also available in: Atom PDF