Project

General

Profile

Actions

Feature #7360

closed

Issue custom query: default query per instance, project and user

Added by Mike Kokhanov about 13 years ago. Updated 3 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Issues
Target version:
Start date:
2011-01-18
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed

Description

It would be nice to be able to create a default custom query, so when I get to issue list of a project, I don't need to select my preferable custom query from the list.


Files

default_custom_query_trunk_r15273.patch (35.4 KB) default_custom_query_trunk_r15273.patch Takenori TAKAKI, 2016-03-23 08:48
default_custom_query_trunk_r15303.patch (20.7 KB) default_custom_query_trunk_r15303.patch Takenori TAKAKI, 2016-04-07 08:42
default-query-settings.png (50.4 KB) default-query-settings.png screenshot - settings Go MAEDA, 2016-04-11 10:55
default-query-list.png (105 KB) default-query-list.png screenshot - issues list Go MAEDA, 2016-04-11 10:55
default_custom_trunk_r17417.patch (21.5 KB) default_custom_trunk_r17417.patch Mizuki ISHIKAWA, 2018-06-26 09:46
default_custom_trunk_r19977.patch (17.4 KB) default_custom_trunk_r19977.patch Olivier Chabert, 2020-08-13 18:09
0001-implements-global-per-project-and-per-user-default-i.patch (24.8 KB) 0001-implements-global-per-project-and-per-user-default-i.patch Olivier's patch, improved and rebased on r21043 Jens Krämer, 2021-06-22 08:24
b.png (92.1 KB) b.png Default query in the general section Marius BĂLTEANU, 2021-07-04 17:59
a.png (141 KB) a.png Default query issues list defaults section Marius BĂLTEANU, 2021-07-04 17:59
7360.patch (23.3 KB) 7360.patch Go MAEDA, 2021-07-05 04:30
fix-performance-when-rendering-sidebar.patch (850 Bytes) fix-performance-when-rendering-sidebar.patch Go MAEDA, 2021-08-02 16:42
fix-performance-when-rendering-sidebar-v2.patch (889 Bytes) fix-performance-when-rendering-sidebar-v2.patch Go MAEDA, 2021-08-03 04:25

Related issues

Related to Redmine - Feature #8479: Global default queryClosed

Actions
Related to Redmine - Feature #5515: user select default issue queryClosed2010-05-12

Actions
Related to Redmine - Feature #4015: Make app settings overridable at project levelNew2009-10-10

Actions
Related to Redmine - Defect #13508: About default filter for assigneeNew

Actions
Related to Redmine - Feature #7659: Add the possibility to sort issues by last_update date, by defaultClosed2011-02-19

Actions
Related to Redmine - Feature #3967: Ability to define default columns to display based on projectClosed2009-10-04

Actions
Related to Redmine - Defect #14753: Remember issue filter for each projectClosed

Actions
Related to Redmine - Feature #35795: Settings for global and user default custom ProjectQueryClosedMarius BĂLTEANU

Actions
Related to Redmine - Defect #36389: Filter parameters of Query string do not work when default query is enabledClosedMarius BĂLTEANU

Actions
Related to Redmine - Patch #36503: Reduce extra queries in IssueQuery.defaultClosedGo MAEDA

Actions
Related to Redmine - Defect #37603: Missing translation for label_default_queries.for_this_userClosedGo MAEDA

Actions
Has duplicate Redmine - Feature #7999: Issue Custom Query: Default QueryClosed2011-01-18

Actions
Has duplicate Redmine - Feature #12689: Default query for every ProjectClosed

Actions
Has duplicate Redmine - Feature #7244: Default query per projectClosed2011-01-07

Actions
Has duplicate Redmine - Feature #16102: Default Filters for queries in a projectClosed

Actions
Has duplicate Redmine - Feature #2829: Ability to set default search filter for IssuesClosed2009-02-24

Actions
Has duplicate Redmine - Feature #7993: Select Default Report (or Custom Report quick links)Closed2011-03-25

Actions
Has duplicate Redmine - Feature #9279: How to Apply custom queries for issues as default view for this projectClosed2011-09-19

Actions
Has duplicate Redmine - Feature #22156: Is there a way to set the filter status to be “Any” by default?Closed

Actions
Has duplicate Redmine - Feature #16249: Configure columns per projectClosed

Actions
Has duplicate Redmine - Feature #15566: Setup a default issue report for each projectClosed

Actions
Has duplicate Redmine - Feature #27128: Ability to choose default sort by column for all projectsClosed

Actions
Has duplicate Redmine - Feature #36198: Set standard columns in the ticket listing options based on projectsClosed

Actions
Has duplicate Redmine - Defect #39041: Default Tickets ViewClosed

Actions
Actions #1

Updated by James Holle about 13 years ago

+1 This would be great!

Actions #2

Updated by Robin McKenzie about 13 years ago

+1 definitely, been wanting this for ages! Ideally each user would be able to determine their own custom query for each project, rather than it being a project-level setting.

Actions #3

Updated by Mike Kokhanov about 13 years ago

  • Assignee set to Azamat Hackimov
Actions #4

Updated by Etienne Massip about 13 years ago

  • Assignee deleted (Azamat Hackimov)
Actions #5

Updated by Vincent Frédérick about 13 years ago

+1 Indeed would be nice for a user to set is default query for a given project. So a user could create a query to see only his tickets or the ticket related to a version he is currently working on. In fact he can already do all of this. Only thing missing is to automatically have that list query displayed when he clicks on "Issues".

Actions #6

Updated by pasquale [:dedalus] almost 13 years ago

+1 very important

Actions #7

Updated by Adam Soltys over 12 years ago

+1

And, if the query is a public query, then you should have the option of specifying whether it's the default for everyone or just your own personal default.

Actions #8

Updated by Victor Freitas about 12 years ago

+1 Very important

Actions #9

Updated by Keven Marin almost 12 years ago

+1 for that feature that we should not forget.

Actions #10

Updated by Chinh Do about 11 years ago

+1 Super important

Actions #11

Updated by Rafael B. about 11 years ago

+1

Reducing just one click seems like such a waste of coding time, but clicking a couple of hundred times every week twice as much is such a waste of effort. This would be a huge usability improvement.

Actions #12

Updated by kangbo kimk about 11 years ago

+1 Very much important. One must click his favorite issus pages when new html page open. It takes a lot of time from many users by redoing that.

Actions #13

Updated by Matthieu Poncin almost 11 years ago

+1 And if the query is public, it would be usefull to have an option to put the query default for every users.

Actions #14

Updated by Miodrag Milic over 10 years ago

+1

Actions #15

Updated by Kent Ou over 10 years ago

+1 I'm going to do that myself

Actions #16

Updated by Maxim Krušina over 10 years ago

+1

Actions #17

Updated by Pierre de LESPINAY over 10 years ago

+1

Actions #18

Updated by Daniel Felix over 10 years ago

Yes this could be quite useful. I have some projects which needs a special filter or a special column display (due to some custom fields) to get displayed correct. If there would be a default view, for each user in each project or a default project with the new role wide filters, this would be great.

Actions #19

Updated by Massimo Rossello about 10 years ago

+1

Actions #20

Updated by Richard Gunn about 10 years ago

+1

Actions #21

Updated by Tim Craig about 10 years ago

+1 Important everyone views important information on issues list without having to select custom query every time.

Actions #22

Updated by Enmos Proje almost 10 years ago

+1
Each time we open the tasks list, every one of us has to rearrange the list before starting to use it. We have custom queries but you forget to select them. This feature would save a huge amount of time and bad language :)

Actions #23

Updated by Roberto Viola almost 10 years ago

+1

Actions #24

Updated by Florian Kaiser almost 10 years ago

+1
That would save me a lot of time.

Actions #25

Updated by Katsuya HIDAKA over 9 years ago

+1
I also hope strongly that this feature is implemented. So, i made the redmine_default_custom_query plugin as an alternative.

Actions #26

Updated by Lajish Lakshmanan over 9 years ago

Takanori2 hidaka Katsuya,
+1

Actions #27

Updated by Florian Kaiser over 9 years ago

Hidaka Katsuya wrote:

+1
I also hope strongly that this feature is implemented. So, I made the redmine_default_custom_query plugin as an alternative.

Maybe you can send a patch file to the redmine developers so they can add it easily.

Actions #28

Updated by Katsuya HIDAKA over 9 years ago

Florian Kaiser wrote:

Maybe you can send a patch file to the redmine developers so they can add it easily.

Yes, i'll try.

Actions #29

Updated by Go MAEDA about 9 years ago

Actions #30

Updated by Go MAEDA about 9 years ago

Actions #31

Updated by Go MAEDA about 9 years ago

  • Related to Feature #5515: user select default issue query added
Actions #32

Updated by Toshi MARUYAMA almost 9 years ago

  • Related to Feature #4015: Make app settings overridable at project level added
Actions #33

Updated by Sebastian Paluch over 8 years ago

+1

This would really make everything more readable and would make life easier for our everyday users.

Actions #34

Updated by Go MAEDA about 8 years ago

  • Related to Feature #22156: Is there a way to set the filter status to be “Any” by default? added
Actions #35

Updated by Takenori TAKAKI about 8 years ago

I made a patch. It integrates Katsuya Hidaka's plugin (redmine_default_custom_query) to Redmine.
I do appreciate Katsuya Hidaka's work. and I would be happy if I could see the feature in Redmine 3.3.0.

this patch is compatibled with latest trunk r15273. and It also includes the test code.

Actions #36

Updated by Takenori TAKAKI about 8 years ago

I have arranged my patch ( default_custom_query_trunk_r15273.patch ) for berow:

  • add 'default_query_id' to "Project(projects) "
  • change position of the 'default-query drop-down', to 'Information Tab'
  • remove permission & module "Manage default query"
  • improve code a little bit, and add tests
  • Compatible with latest trunk (r15303)
Actions #37

Updated by Go MAEDA about 8 years ago

  • Target version set to 3.3.0

default_custom_query_trunk_r15303.patch works fine and passed all test.

This is a great feature. Many users hope for this feature (this issue have got 24 "+1"s and the original plugin redmine_default_custom_query written by Katsuya HIDAKA have got 25 stars on GitHub).

It would be great if we could see this feature in the next release. Now I am setting target version to 3.3.0.

Actions #38

Updated by Go MAEDA about 8 years ago

Screenshots of the patch, contributed by Katsuya HIDAKA and Takenori TAKAKI.

screenshot - settings

screenshot - issues list

Actions #39

Updated by Katsuya HIDAKA almost 8 years ago

+1 I'm creator of Default Custom Query plugin. I think that this patch (based on Default Custom Query plugin and written by Takenori Takaki) is one of the best way for providing customization of default issues for each project. I hope that this feature is merged!!

Actions #40

Updated by Jean-Philippe Lang almost 8 years ago

  • Target version changed from 3.3.0 to 3.4.0

As requested above, we should provide different level of default query: per project (as implemented in the patch) but also by user. We should also be able to provide default queries for the global issue list.

Actions #41

Updated by Go MAEDA almost 8 years ago

  • Has duplicate Feature #16102: Default Filters for queries in a project added
Actions #42

Updated by Nils Grimm almost 8 years ago

+1, this would be wonderful.

Actions #43

Updated by JW Fuchs over 7 years ago

+1

Actions #44

Updated by Go MAEDA over 7 years ago

  • Related to Defect #13508: About default filter for assignee added
Actions #45

Updated by Luiz Moura over 7 years ago

+1

Actions #47

Updated by Go MAEDA over 7 years ago

  • Has duplicate Feature #2829: Ability to set default search filter for Issues added
Actions #48

Updated by Go MAEDA over 7 years ago

  • Has duplicate Feature #7993: Select Default Report (or Custom Report quick links) added
Actions #49

Updated by Florian Riedel over 7 years ago

+1

Actions #50

Updated by Go MAEDA over 7 years ago

  • Has duplicate Feature #9279: How to Apply custom queries for issues as default view for this project added
Actions #51

Updated by Go MAEDA about 7 years ago

  • Related to Feature #7659: Add the possibility to sort issues by last_update date, by default added
Actions #52

Updated by Stefan Lindner about 7 years ago

+1

Actions #53

Updated by Ilya Potapov about 7 years ago

+1

Actions #54

Updated by Toshi MARUYAMA about 7 years ago

  • Related to Feature #3967: Ability to define default columns to display based on project added
Actions #55

Updated by Hirofumi Kadoya almost 7 years ago

+1 

Actions #56

Updated by Jean-Philippe Lang almost 7 years ago

  • Target version deleted (3.4.0)
Actions #57

Updated by Mischa The Evil almost 7 years ago

  • Target version set to Unplanned backlogs

Let's try to keep this on the roadmap; setting target to unplanned.

Actions #58

Updated by Go MAEDA over 6 years ago

  • Related to Defect #14753: Remember issue filter for each project added
Actions #59

Updated by Jules Bowie over 6 years ago

+1

Actions #60

Updated by Go MAEDA over 6 years ago

  • Related to Feature #27128: Ability to choose default sort by column for all projects added
Actions #61

Updated by Ilya Prokazov over 6 years ago

+1

Actions #62

Updated by Toshi MARUYAMA over 6 years ago

  • Related to deleted (Feature #22156: Is there a way to set the filter status to be “Any” by default?)
Actions #63

Updated by Toshi MARUYAMA over 6 years ago

  • Has duplicate Feature #22156: Is there a way to set the filter status to be “Any” by default? added
Actions #64

Updated by Yar n about 6 years ago

+1

Actions #65

Updated by Mizuki ISHIKAWA almost 6 years ago

+1

The patch of #7360#note-36 which was not working according to version upgrade was fixed to work on trunk.
I would like the continuation of work to realize this feature.

Actions #66

Updated by Go MAEDA almost 6 years ago

Actions #67

Updated by Tim Fischbach over 5 years ago

+1

Actions #68

Updated by Marcel Müller about 5 years ago

+1 !
Is there any reason this feature / patch got rejected? Would be really useful to have something like this... Maybe 4.1.0?!

Actions #69

Updated by FX Deltombe about 5 years ago

+1 !

Actions #70

Updated by LEXO IT Services Switzerland about 5 years ago

+1!
I hope that this feature will be release soon too. It's very annoying. It should be possible to define a global default filter and then save a dedicated filter per project.

Actions #71

Updated by Michael Barry almost 5 years ago

I would like to throw my +1 into the ring! This functionality would be super beneficial to have native to Redmine. Crossing my fingers for 4.1.0 (or sooner!)...

Actions #72

Updated by Ryoji Takeuchi over 4 years ago

+1
Is this patch workable on 4.0.4 ? Because "redmine_default_custom_query" is conflict with DMSF. So I am seeking another solution with same function.

Actions #73

Updated by Simon Busse over 4 years ago

+1

Actions #74

Updated by Marcel Müller almost 4 years ago

I really would like to see this integrated in redmine by default. It was more or less accepted in https://www.redmine.org/issues/7360#note-40 - any idea why its now on unplanned backlog?

Actions #75

Updated by Go MAEDA almost 4 years ago

Marcel Müller wrote:

I really would like to see this integrated in redmine by default. It was more or less accepted in https://www.redmine.org/issues/7360#note-40 - any idea why its now on unplanned backlog?

The current patch was rejected by Jean-Philippe Lang in #7360#note-40 because of the lack of per-user default query and a default query for the cross-project issues list.

To push this issue forward, someone needs to implement at least those features.

Actions #76

Updated by Olivier Chabert over 3 years ago

Hi,

You can find an updated version of patch for this feature.
This patch work with last commit r19977 on trunk branch.

this patch provide also different level of default query (as requested on #7360#note-40): * per project (as implemented in the original patch) * per user * and in the global redmine settings for the global issue list

thank you for your reviews on this patch ;)

Actions #77

Updated by Olivier Chabert over 3 years ago

Hello,

Does anyone have time to review my patch ?

thanks ;)

Actions #78

Updated by Ribald Drobens over 3 years ago

+1, absolutely! Seeing all issues ordered by issue # per default is definitively suboptimal behaviour in my eyes.

Actions #79

Updated by Jan Vonde about 3 years ago

Oliver Cordero Chabert: Thanks for your effort. Can you confirm that the patch works with Redmine 4.1.2?

Michael Glyebov Kokhanov: Please can you review this patch, comment, or forward this to someone else for reviewing?

Actions #80

Updated by Jens Krämer almost 3 years ago

We're planning to introduce this feature in Planio , so I took the liberty to look over Olivier's patch (thank you for that!) and, among other things, rebased it on current master.

Further, I added some tests and German translations, fixed any rubocop warnings, implemented copying of the default query assignment when copying a project including queries, and changed the naming of preferences / fields to be consistently default_issue_query.

Actions #81

Updated by Jan Vonde almost 3 years ago

Jens Priesen Krämer: Do you know anything I can do to get the patch into the main code?

Actions #82

Updated by Go MAEDA almost 3 years ago

  • Target version changed from Unplanned backlogs to 5.0.0

Setting the target version to 5.0.0.

Actions #83

Updated by Marius BĂLTEANU almost 3 years ago

The patch looks good to me, nice work!

Only one thing, is not better to show the Default query field inside Issues list defaults section in admin? The settings are quite related:

Current proposal:
Default query issues list defaults section

My proposal:
Default query in the general section

Actions #84

Updated by Go MAEDA almost 3 years ago

Marius BALTEANU wrote:

Only one thing, is not better to show the Default query field inside Issues list defaults section in admin? The settings are quite related:

+1
The setting "Default query" is exactly "Issue list defaults"!

I have updated the patch as such and changed the date of the migration file to the current date.

Although an earlier version of the patch contributed by Katsuya HIDAKA and Takenori TAKAKI was rejected by JPL 5 years ago (#7360#note-40), I got approval from Jean-Philippe Lang to commit the latest patch the day before yesterday. I would like to commit the patch within the next few days.

Actions #85

Updated by Go MAEDA almost 3 years ago

  • Status changed from New to Closed
  • Assignee set to Go MAEDA
  • Resolution set to Fixed

Committed the patch. Thank you to all those who contributed to this great feature, and special thanks to Katsuya HIDAKA, the author of Redmine Default Custom Query.

Now you can set the default issue query per app/project/user. The project-level default query always overrides the app-level one, and the user-level one always overrides the project-level and app-level ones.

You can configure default queries in the following places:

  • App-level: Administration > Issue tracking > Default Query
  • Project-level: Settings (project) > Issue tracking > Default issue query
  • User-level: My account > Default issue query
Actions #86

Updated by Go MAEDA almost 3 years ago

  • Has duplicate Feature #15566: Setup a default issue report for each project added
Actions #87

Updated by Go MAEDA over 2 years ago

The current code executes as many SQL statements as the number of queries displayed in the sidebar. It may cause a performance issue when many custom queries are displayed in the sidebar.

The attached patch fixes the problem.

Before:

  IssueQuery Load (0.1ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" = ? LIMIT ?  [["type", "IssueQuery"], ["id", 4], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  Rendered issues/_sidebar.html.erb (Duration: 33.7ms | Allocations: 5906)

After:

  IssueQuery Load (0.1ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" = ? LIMIT ?  [["type", "IssueQuery"], ["id", 4], ["LIMIT", 1]]
  CACHE IssueQuery Load (0.0ms)  SELECT "queries".* FROM "queries" WHERE "queries"."type" = ? AND "queries"."id" IS NULL LIMIT ?  [["type", "IssueQuery"], ["LIMIT", 1]]
  Rendered issues/_sidebar.html.erb (Duration: 18.3ms | Allocations: 3276)

Actions #88

Updated by Go MAEDA over 2 years ago

Go MAEDA wrote:

The current code executes as many SQL statements as the number of queries displayed in the sidebar. It may cause a performance issue when many custom queries are displayed in the sidebar.

The attached patch fixes the problem.

Attaching a simpler and more efficient version of the patch.

Actions #89

Updated by Mischa The Evil over 2 years ago

Go MAEDA wrote:

Attaching a simpler and more efficient version of the patch.

FWIW, the following assignment:

default_query =
  default_query_by_class[query.class] ||
  default_query_by_class[query.class] = query.class.default(project: @project)

can (possibly) be shortened to:

default_query =
  default_query_by_class[query.class] ||= query.class.default(project: @project)

Ref. on StackOverflow.

Actions #90

Updated by Go MAEDA over 2 years ago

  • Status changed from Reopened to Closed

Committed patch #7360#note-88 with the change suggested by Mischa The Evil in #7360#note-89.

Actions #91

Updated by Mischa The Evil over 2 years ago

  • Related to Feature #35795: Settings for global and user default custom ProjectQuery added
Actions #92

Updated by Marius BĂLTEANU over 2 years ago

Before committing #35795, I would like to change the local setting_default_issue_query to setting_default_query in order to not add a new key (setting_default_project_query) to locales with the same translation ("Default query").

Go Maeda, do you see any problem?

Actions #93

Updated by Marius BĂLTEANU over 2 years ago

  • Status changed from Closed to Reopened
Actions #94

Updated by Marius BĂLTEANU over 2 years ago

  • Related to deleted (Feature #27128: Ability to choose default sort by column for all projects)
Actions #95

Updated by Marius BĂLTEANU over 2 years ago

  • Has duplicate Feature #27128: Ability to choose default sort by column for all projects added
Actions #96

Updated by Go MAEDA over 2 years ago

  • Assignee changed from Go MAEDA to Marius BĂLTEANU

Marius BALTEANU wrote:

Before committing #35795, I would like to change the local setting_default_issue_query to setting_default_query in order to not add a new key (setting_default_project_query) to locales with the same translation ("Default query").

Go Maeda, do you see any problem?

I think there isn't any problem. And all existing translations for the key don't include a word corresponding to 'issue', so it is safe to simply change the name of the key.

config/locales/bg.yml:  setting_default_issue_query: Заявка по подразбиране
config/locales/de.yml:  setting_default_issue_query: Standardabfrage
config/locales/fr.yml:  setting_default_issue_query: Rapport par défaut
config/locales/gl.yml:  setting_default_issue_query: Consulta por defecto
config/locales/ja.yml:  setting_default_issue_query: デフォルトのクエリ
config/locales/zh-TW.yml:  setting_default_issue_query: 預設查詢
Actions #97

Updated by Marius BĂLTEANU over 2 years ago

  • Status changed from Reopened to Closed
  • Assignee changed from Marius BĂLTEANU to Go MAEDA

Go MAEDA wrote:

I think there isn't any problem. And all existing translations for the key don't include a word corresponding to 'issue', so it is safe to simply change the name of the key.

Thanks, change committed.

Actions #98

Updated by Marius BĂLTEANU over 2 years ago

  • Subject changed from Issue Custom Query: Default Query to Issue custom query: default query per instance, project and user
Actions #99

Updated by Marius BĂLTEANU over 2 years ago

  • Has duplicate Feature #36198: Set standard columns in the ticket listing options based on projects added
Actions #100

Updated by Marius BĂLTEANU over 2 years ago

  • Related to Defect #36389: Filter parameters of Query string do not work when default query is enabled added
Actions #101

Updated by Marius BĂLTEANU about 2 years ago

  • Status changed from Closed to Reopened

I'm reopening this in order to validate the fix for the issue reported in #36389.

Jens Krämer, can you take a look, please?

Actions #102

Updated by Go MAEDA about 2 years ago

  • Related to Patch #36503: Reduce extra queries in IssueQuery.default added
Actions #103

Updated by Marius BĂLTEANU about 2 years ago

  • Status changed from Reopened to Closed

I've committed the fix.

Actions #104

Updated by Holger Just over 1 year ago

  • Related to Defect #37603: Missing translation for label_default_queries.for_this_user added
Actions #105

Updated by Holger Just 7 months ago

Actions #106

Updated by Dmitry Nekrasov 3 months ago

Can get default query working only on user level and on global level (all issues of all projects).
Selecting on default query project level does not work, even if public query is selected.

Environment:
Redmine version 5.1.1.stable
Ruby version 2.7.4-p191 (2021-07-07) [x86_64-linux-gnu]
Rails version 6.1.7.6
Environment production
Database adapter Mysql2
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
Redmine settings:
Redmine theme Zenmine-510 (includes JavaScript)
SCM:
Git 2.30.2
Filesystem
Redmine plugins:
additional_tags 3.0.9
additionals 3.0.8
computed_custom_field 1.0.7
mega_calendar 1.9.6
redmine_checklists 3.1.22
redmine_custom_workflows 2.0.8
redmine_image_clipboard_paste 3.3.0
redmine_impersonate 2.0.0
redmine_issue_dynamic_edit 0.8.1
redmine_issue_view_columns 1.0.1
redmine_issues_tree 0.0.15
redmine_mentions 0.0.1
redmine_messenger 1.0.15
redmine_wysiwyg_editor 0.32.0
redmine_x_lightbox2 1.0.0

Actions

Also available in: Atom PDF