Feature #1565

Custom query on My page

Added by Andrea Maleci almost 9 years ago. Updated 2 months ago.

Status:ClosedStart date:2008-07-03
Priority:NormalDue date:
Assignee:Jean-Philippe Lang% Done:

0%

Category:My page
Target version:3.4.0
Resolution:Fixed

Description

Should be nice to add on my page folder a saved custom query.

master_1565.diff Magnifier - patch against master (11.5 KB) Jens Krämer, 2015-02-09 13:27

2.6_stable_1565.diff Magnifier - patch against 2.6-stable (11.5 KB) Jens Krämer, 2015-02-09 13:28

rm_1565_issues_from_custom_query.patch Magnifier (7.82 KB) Marius BALTEANU, 2017-02-27 22:42

my-page-query-setting.png (27 KB) Go MAEDA, 2017-03-01 14:55

my-page-query.png (69.7 KB) Go MAEDA, 2017-03-01 14:55

rm_1565_issues_from_custom_query.patch Magnifier (8.03 KB) Marius BALTEANU, 2017-03-10 09:20


Related issues

Related to Redmine - Feature #662: Make issue lists on "My Page" customizable Closed 2008-02-13
Related to Redmine - Feature #12223: Make "My Page"-Widgets filterable Closed
Related to Redmine - Feature #574: Add "My issues" to main menu New
Related to Redmine - Feature #12789: Redmine - design study New
Duplicated by Redmine - Patch #3220: Custom queries as my page widget Closed 2009-04-22
Duplicated by Redmine - Feature #2881: Direct links to Custom queries on "My Page" Closed
Duplicated by Redmine - Patch #217: New "Open Issues assigned to me" view for /my/page Closed
Duplicated by Redmine - Feature #8808: My custom queries on My page Closed 2011-07-14
Duplicated by Redmine - Feature #8228: Allow custom filter to be used on "My Page". Closed 2011-04-26
Duplicated by Redmine - Feature #8304: Add custom queries to "My Page" Closed 2011-05-05
Duplicated by Redmine - Feature #1710: ability to change the query that displays "Issues Assigne... Closed 2008-07-29
Duplicated by Redmine - Feature #1051: My Page - Customisaton / Default behaviour - Reported Issues Closed 2008-04-13
Duplicated by Redmine - Feature #4677: Add a filter on the "My reported issues" block Closed 2010-01-28
Duplicated by Redmine - Feature #4001: Configuration of My page Closed 2009-10-08
Duplicated by Redmine - Feature #6707: Order of my Issues Closed 2010-10-20
Duplicated by Redmine - Feature #5563: provide more information about "target version" Closed 2010-05-20
Duplicated by Redmine - Feature #9479: Add a custom filtered issues block to 'My page' Closed 2011-10-27

Associated revisions

Revision 16400
Added by Jean-Philippe Lang 3 months ago

Let user choose columns and sort order of issue lists on "My page" (#1565).

Revision 16404
Added by Jean-Philippe Lang 3 months ago

Adds UI test for sorting issues on "My page" (#1565).

Revision 16406
Added by Jean-Philippe Lang 2 months ago

Let user display a custom query on "My page" (#1565).

Revision 16409
Added by Jean-Philippe Lang 2 months ago

Fix link to issues when displaying a project query (#1565).

Revision 16413
Added by Jean-Philippe Lang 2 months ago

Allow multiple instances of custom queries on My page (#1565).

Revision 16415
Added by Jean-Philippe Lang 2 months ago

Fix tests (#1565).

History

#1 Updated by Johann Chaves over 6 years ago

Does anybody knows what happened to this issue?

#2 Updated by Mischa The Evil over 6 years ago

Johann Chaves wrote:

Does anybody knows what happened to this issue?

AFAICS: nothing (yet)...

#3 Updated by James Rowe over 6 years ago

I agree. Should be able to have custom queries as a droppable block on my page.

Take the look and feel of 'issues I'm watching' and put in issues returned from a custom query.

+1

#4 Updated by Landon Harsh over 6 years ago

There is a plugin called "MyPage custom queries" that will do this, but it does not honor the columns from the query which I think is critical.

+1 for this with the columns from the query honored.

#5 Updated by Irfan Adilovic over 6 years ago

+1

I don't have a use for closed issues in the watched and reported issues queries; I'd like to customize them or replace them with custom ones.

#6 Updated by Tobias Verbeke over 6 years ago

+1

would significantly reduce clicking around to have a quick overview when starting to work; this feature request was the first one team members made since the introduction of redmine for our project management

#7 Updated by Milan Stastny over 6 years ago

MyPage custom queries is my quick creation withouth much of a testing and feedback from anybody, so if you try it out and find out that it works close to your liking I'll be more than happy to finish it. Just let me know, on github/mail, anywhere.

#8 Updated by Landon Harsh over 6 years ago

I am utilizing the MyPage custom queries plugin. I thought it was going to do exactly what I wanted, but I was a bit disappointed for one reason. It does not honor the specifics of the query, displayed coloumns, sort order, those kinds of things. If it did honor all parameters of the query, this would be a perfect solution for my particular situation.

I appreciate what you have done so far, it is a great start! Thank you.

#9 Updated by Ladislav Nesnera over 6 years ago

These tickets seem be related or duplicate too:

#10 Updated by Etienne Massip about 6 years ago

  • Category set to My page

#11 Updated by Pavel Pivovarov about 6 years ago

So whats happening with that feature? Has anyone find solution?

#12 Updated by Ladislav Nesnera about 6 years ago

I'm afraid there is nobody who care this feature :-(

#14 Updated by Ivan Cenov almost 6 years ago

+1

#15 Updated by Josh Davidson almost 6 years ago

+1. Customizing the "my page" calendar based on query would also be welcome.

#16 Updated by Cyril Dubus almost 6 years ago

+1 That feature would be more than great ! I'm so frustrated when I click on "My page" and I cannot see the issues I want to see.

#17 Updated by Michael Kling over 5 years ago

+1 :D

#18 Updated by Steven Bidny over 5 years ago

+1

#19 Updated by Julian Xhokaxhiu over 5 years ago

C'mon, other issue tracker does have this (like Mantis or Trac). +1!

#20 Updated by Hannes Meier over 5 years ago

+1

#21 Updated by John Wilcox over 5 years ago

This feature would be very useful. As it is now, the "my page" is a bit pointless, since custom queries are not available and default listing is not sufficient at all.

#22 Updated by Stephan Georg over 5 years ago

+1 would really be helpful and improving usability.

#23 Updated by Yassen Damyanov about 5 years ago

+1 We badly need this functionality to provide customized blocks on "My Page" for various cases.

#24 Updated by Attila Nagy about 5 years ago

+1

#25 Updated by Kenneth Scott about 5 years ago

+1

#26 Updated by Wim DePreter about 5 years ago

+1

#29 Updated by Vladimir Pitin almost 5 years ago

+1

#30 Updated by Schollii Tron almost 5 years ago

This is clearly a much needed feature. Shouldn't this ticket's priority be upped? Also, could someone with required permisssions add the tickets mentioned in "duplicates" from comment 9 to the "related" for this ticket?

From looking at all these tickets, a view block that allows you to display one of your saved reports would do the trick, no? Even better, if you could "instantiate" more than one of those view blocks, as some people want to see several reports simultaneously.

#31 Updated by Christopher Bebry over 4 years ago

+1

#32 Updated by Gary Barclay over 4 years ago

+1 for me...I won't upgrade until this feature is implemented.
We are using the plugin MyPage queries which allows us to create lists of auto generated issues of a specific type.

#33 Updated by Pat Mächler over 4 years ago

+1

#34 Updated by Eugene Fokin over 4 years ago

+1

#35 Updated by Bob Walasek over 4 years ago

+1 This would be a great feature!

#36 Updated by Leos Prikryl about 4 years ago

+1

#37 Updated by Dipan Mehta about 4 years ago

+1. This is a very demanded feature in our company.

#38 Updated by Leos Prikryl about 4 years ago

This plugin https://github.com/Undev/redmine_my_page_queries works fine with Redmine 2.3.0.

#39 Updated by Dipan Mehta about 4 years ago

Leos Prikryl wrote:

This plugin https://github.com/Undev/redmine_my_page_queries works fine with Redmine 2.3.0.

This is a great plugin and works! This really transforms the "my page" experience. However, I saw one limitation. The regular query page allows you to sort the issue list based on different fields where as here they are only based on issue ID. Is it possible to provide sort order?

Thanks for the plugin.

#40 Updated by Leos Prikryl about 4 years ago

Dipan Mehta wrote:

This is a great plugin and works! This really transforms the "my page" experience. However, I saw one limitation. The regular query page allows you to sort the issue list based on different fields where as here they are only based on issue ID. Is it possible to provide sort order?

Thanks for the plugin.

It's not my plugin. I just found it. You would have to contact the authors with your feature request.

#41 Updated by Ralph Twele about 4 years ago

+1 I could not get https://github.com/Undev/redmine_my_page_queries to work on my Redmine 2.3.0 Bitnami native stack for Windows.

#42 Updated by Leos Prikryl about 4 years ago

I am running https://github.com/Undev/redmine_my_page_queries successfully on Redmine 2.3.0 Bitnami native stack for Windows. If you need help, please send me details of your problem to .

#43 Updated by Sven Wermers almost 4 years ago

+1

#44 Updated by Toshi MARUYAMA over 3 years ago

#45 Updated by firzen pan over 3 years ago

Ralph Twele wrote:

+1 I could not get https://github.com/Undev/redmine_my_page_queries to work on my Redmine 2.3.0 Bitnami native stack for Windows.

It works fine on my redmine 2.3.3 Bitnami stack for linux. Great works!!!

#46 Updated by Marc M. over 3 years ago

+1

#47 Updated by Kevin Palm about 3 years ago

+1

#48 Updated by Toshi MARUYAMA almost 3 years ago

  • Related to Feature #17006: Hide issues from closed project on my page added

#49 Updated by Toshi MARUYAMA almost 3 years ago

  • Related to deleted (Feature #17006: Hide issues from closed project on my page)

#50 Updated by Toshi MARUYAMA almost 3 years ago

  • Duplicated by Feature #1710: ability to change the query that displays "Issues Assigned to me" on the My Page added

#51 Updated by Toshi MARUYAMA almost 3 years ago

  • Duplicated by Feature #1051: My Page - Customisaton / Default behaviour - Reported Issues added

#52 Updated by Toshi MARUYAMA almost 3 years ago

  • Duplicated by Feature #4677: Add a filter on the "My reported issues" block added

#53 Updated by Toshi MARUYAMA almost 3 years ago

#54 Updated by Toshi MARUYAMA almost 3 years ago

  • Related to Feature #574: Add "My issues" to main menu added

#55 Updated by Toshi MARUYAMA almost 3 years ago

#56 Updated by Toshi MARUYAMA almost 3 years ago

  • Duplicated by Feature #5563: provide more information about "target version" added

#58 Updated by Antonio De Marinis almost 3 years ago

+1
This is really a much wanted feature that would lift up redmine to become similar to thise kanban-like system like trello, kanbanize, targetprocess and so on.

What those system are good at is to provide the "kanban board" column view of issues.

if we just implement this feature with a flexible multi-column/grid layout, you have basically got a very powerfull and flexible board anybody can share.

This would make also several scrum/kanban redmine plugins redundant and obsolete. Users would not need to feel the need to move to other modern kanban systems.

#59 Updated by Youssoupha Sambe over 2 years ago

+1
This feature is vital for Redmine, for it just increase rentability of the application.

The only available plugin for this is not "complete" as it just allow query editing.

Furthermore there is no point, I think, having a table and not be able to sort it and/or edit the columns using the UI.

Personally I need it to allow users to see the issues that are assigned to them with due date, and I need the widget to be editable like the table in issue tab.

#60 Updated by Olivier Houdas over 2 years ago

+1
People in our company also request me (their Redmine admin) to be able to use their own filter as a Mypage component.

#61 Updated by Matthew Seng over 2 years ago

+1
Will be a great feature to have.

#62 Updated by jean forichon over 2 years ago

Yes we need that!

#63 Updated by Jens Krämer over 2 years ago

Hi,

we just built that here at Planio, and we'd really like to see this make its way into Redmine Core.

This patch enables users to add any number of custom queries to their 'My page'. For the sake of consistency the number of issues shown for each query is limited to 10, as is the case with the pre-defined issue blocks. Going further and to make this even more useful, it would be nice to have a way to give users the ability to change this limit either globally or per block.

Attached you find patches for current master and 2.6-stable branch.

Cheers,
Jens

#64 Updated by Jan from Planio www.plan.io over 2 years ago

  • Assignee set to Jean-Baptiste Barth

Jean-Baptiste, are you still looking for "committable" patches? This one is a bit lengthy, but in my opinion it's a great improvement for the My Page section and telling by the +1's here on redmine.org and from our clients at Planio, I think it would be well received.

#65 Updated by Tobias Fischer over 2 years ago

Awesome, thank you Jens! :)

I did basic tests with latest 2.6 branch and can confirm the 2.6_patch works well!

Would be great if we could have this implemented in the next redmine version...

#66 Updated by Le Distordu about 2 years ago

+1 High priority !!!

#67 Updated by Chet Wang about 2 years ago

I'm using redmine 3.0.1, but this feature is still missing....
@Jens Krämer
Is your patch available to redmine v3? or could you please provide an v3 compatible patch?

#68 Updated by Chet Wang about 2 years ago

Could someone re-assign this issue to Jean-Philippe Lang? It seems that Jean-Baptiste Barth hasn't been logging in redmine.org for months!

#69 Updated by Rupesh J about 2 years ago

@Chet and others, This may be interesting for you guys..
Redmine My Page Plugin

#70 Updated by Chet Wang about 2 years ago

Rupesh J wrote:

@Chet and others, This may be interesting for you guys..
Redmine My Page Plugin

This is great! I suggest you register it into redmine plugin repository. I will give you 5 stars!

#71 Updated by Toshi MARUYAMA about 2 years ago

  • Duplicated by Feature #9479: Add a custom filtered issues block to 'My page' added

#72 Updated by Toshi MARUYAMA about 2 years ago

#73 Updated by Jean Louis about 1 year ago

+1

#74 Updated by Sergey Startsev 12 months ago

+1

#75 Updated by Rupesh J 12 months ago

Chet Wang wrote:

This is great! I suggest you register it into redmine plugin repository. I will give you 5 stars!

Its already registered : http://www.redmine.org/plugins/redmine_my_page

#76 Updated by Marius BALTEANU 3 months ago

I made a patch that implements a new block which returns the issues from a selected query. For consistency with the other issue blocks, I chose to limit the results to 10 and use the same columns. I think that customising the number of results and the columns displayed should be made in other ticket and should be available for all issue blocks.

#77 Updated by Go MAEDA 3 months ago

These are screenshots of Marius BALTEANU's patch attached on #1565#note-76.

#78 Updated by Go MAEDA 3 months ago

  • Assignee deleted (Jean-Baptiste Barth)
  • Target version changed from Candidate for next major release to 3.4.0

Many users have been waiting for this feature (40 "+1"s, 13 duplicate issues).
Setting target version to 3.4.0.

#79 Updated by Jean-Philippe Lang 3 months ago

Thanks for the patch Marius. I think it would make sense to render the query with its column (instead of the default one used for other lists on "my page"), what do you think?

#80 Updated by Marius BALTEANU 3 months ago

It'll be great to render the query with its column. That means we should use the list partial instead of the list_simple or to modify the list_simple to support custom columns. Another benefit of list partial is the grouping feature.

Please let me know which solution sounds better for you.

#81 Updated by Jean-Philippe Lang 3 months ago

I've just made a few changes to the "list" partial in order to use local variables, we should be able to use it.

#82 Updated by Marius BALTEANU 3 months ago

Thanks, I'll update the patch.

#83 Updated by Marius BALTEANU 3 months ago

Here it is the updated patch. Issues are now rendered using the "list" partial with these features: custom columns, sorting and grouping.

The number of issues displayed are still limited to 10. We should change this too and make it configurable in the block?

#84 Updated by Jean-Philippe Lang 2 months ago

  • Status changed from New to Closed
  • Assignee set to Jean-Philippe Lang
  • Resolution set to Fixed
Thanks Marius, I've reworked the patch a bit after I made more changes to the management of "My page". I've also implemented the possibility for some blocks to be displayed multiple times, with different settings. So it's now possible:
  • to select the columns and sort order of existing issue lists (assigned, reported and watched issues)
  • to display up to 3 custom queries

I think we can close it.

#85 Updated by Marius BALTEANU 2 months ago

Thanks Jean-Philippe Lang! I tested all of your changes regarding "My page" and they looks very good. I'm impressed :)

I have only one small observation, it is ok to let the user to add the same custom query multiple times?

Also, I'm thinking now that could be quite useful to add two new options for each block:
- refresh the block: for users who want to refresh only one block from my page
- full screen: for users who want to view a block on full screen.
For both of them I'll open a new issue when I've the patches ready.

Also available in: Atom PDF