Vote #63539: Custom query on My page - redmineorg-copy202205 - Redmine

編集操作

リンクをコピー

Vote #63539

完了

Custom query on My page

Admin Redmine さんが4年以上前に追加. 4年以上前に更新.

ステータス:

Closed

優先度:

通常

担当者:

カテゴリ:

My page_42

対象バージョン:

3.4.0_119

開始日:

2008/07/03

期日:

進捗率:

予定工数:

Redmineorg_URL:

https://www.redmine.org/issues/1565

category_id:

version_id:

119

issue_org_id:

1565

author_id:

1461

assigned_to_id:

comments:

status_id:

tracker_id:

plus1:

affected_version:

closed_on:

affected_version_id:

ステータス-->[Closed]

引用

説明

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

journals

Does anybody knows what happened to this issue?
--------------------------------------------------------------------------------
Johann Chaves wrote:
> Does anybody knows what happened to this issue?

AFAICS: nothing (yet)...
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
+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.
--------------------------------------------------------------------------------
+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

--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
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.

--------------------------------------------------------------------------------
These tickets seem be related or duplicate too:
* duplicate
** #1991
** #1710
** #1051
** #662
** #4677
** #4001
** #493 (remaining paragraph 4)
* related
** #2471
** #2714
** #6707
** #5563

--------------------------------------------------------------------------------
So whats happening with that feature? Has anyone find solution?
--------------------------------------------------------------------------------
I'm afraid there is nobody who care this feature :-(
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1. Customizing the "my page" calendar based on query would also be welcome.
--------------------------------------------------------------------------------
+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.
--------------------------------------------------------------------------------
+1 :D
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
C'mon, other issue tracker does have this (like Mantis or Trac). +1!
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
+1 would really be helpful and improving usability.
--------------------------------------------------------------------------------
+1 We badly need this functionality to provide customized blocks on "My Page" for various cases.
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1, though check out https://github.com/alvila/redmine_my_page_queries
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+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.
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1 This would be a great feature!
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1. This is a very demanded feature in our company.
--------------------------------------------------------------------------------
This plugin https://github.com/Undev/redmine_my_page_queries works fine with Redmine 2.3.0.
--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
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.

--------------------------------------------------------------------------------
+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.
--------------------------------------------------------------------------------
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 leos.prikryl@gmail.com.
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
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!!!
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+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.

--------------------------------------------------------------------------------
+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.
--------------------------------------------------------------------------------
+1
People in our company also request me (their Redmine admin) to be able to use their own filter as a Mypage component.
--------------------------------------------------------------------------------
+1
Will be a great feature to have.
--------------------------------------------------------------------------------
Yes we need that!
--------------------------------------------------------------------------------
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
--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
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...
--------------------------------------------------------------------------------
+1 High priority !!!
--------------------------------------------------------------------------------
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?
--------------------------------------------------------------------------------
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!
--------------------------------------------------------------------------------
@Chet and others, This may be interesting for you guys..
"Redmine My Page Plugin":https://github.com/jrupesh/redmine_my_page

--------------------------------------------------------------------------------
Rupesh J wrote:
> @Chet and others, This may be interesting for you guys..
> "Redmine My Page Plugin":https://github.com/jrupesh/redmine_my_page

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

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
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

--------------------------------------------------------------------------------
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.

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

!{border: 1px solid #ccc;}.my-page-query-setting.png!

!{border: 1px solid #ccc;}.my-page-query.png!
--------------------------------------------------------------------------------
Many users have been waiting for this feature (40 "+1"s, 13 duplicate issues).
Setting target version to 3.4.0.
--------------------------------------------------------------------------------
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?
--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
I've just made a few changes to the "list" partial in order to use local variables, we should be able to use it.
--------------------------------------------------------------------------------
Thanks, I'll update the patch.
--------------------------------------------------------------------------------
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?
--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
Why only 3 custom queries?

--------------------------------------------------------------------------------
I just stumbled over that 3 custom query limit too. I would very much like to use more queries :(
--------------------------------------------------------------------------------
Martin von Wittich wrote:
> I just stumbled over that 3 custom query limit too. I would very much like to use more queries :(

Please create new feature issue because this issue is closed.
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
Toshi MARUYAMA wrote:
> Martin von Wittich wrote:
> > I just stumbled over that 3 custom query limit too. I would very much like to use more queries :(
>
> Please create new feature issue because this issue is closed.

#27313
--------------------------------------------------------------------------------
I still do not understand: is it possible to edit the list of queries of the "My page block" dropdown menu?
If yes, how can that be done?

thanks!
--------------------------------------------------------------------------------
Marcello Lussana wrote:
> I still do not understand: is it possible to edit the list of queries of the "My page block" dropdown menu?
> If yes, how can that be done?

Please use forum for question.
This issue is closed.
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

related_issues

relates,Closed,662,Make issue lists on "My Page" customizable
relates,Closed,12223,Make "My Page"-Widgets filterable
relates,New,574,Add "My issues" to main menu
relates,New,12789,Redmine - design study
relates,Closed,23574,Issue subjects are truncated at 60 characters on my page
relates,New,27313,More custom queries on My page
relates,Closed,2920,filter issues assigned to me by project
relates,Closed,9314,Filtering query with statement condition not mantain sort criteria
duplicates,Closed,3220,Custom queries as my page widget
duplicates,Closed,2881,Direct links to Custom queries on "My Page"
duplicates,Closed,217,New "Open Issues assigned to me" view for /my/page
duplicates,Closed,8808,My custom queries on My page
duplicates,Closed,8228,Allow custom filter to be used on "My Page".
duplicates,Closed,8304,Add custom queries to "My Page"
duplicates,Closed,1710,ability to change the query that displays "Issues Assigned to me" on the My Page
duplicates,Closed,1051,My Page - Customisaton / Default behaviour - Reported Issues
duplicates,Closed,4677,Add a filter on the "My reported issues" block
duplicates,Closed,4001,Configuration of My page
duplicates,Closed,6707,Order of my Issues
duplicates,Closed,5563,provide more information about "target version"
duplicates,Closed,9479,Add a custom filtered issues block to 'My page'

編集操作

リンクをコピー

他の形式にエクスポート: Atom PDF

プロジェクト

全般

プロフィール

redmineorg-copy202205

カスタムクエリ

Vote #63539

Custom query on My page

Admin Redmine さんが4年以上前に更新

編集

unofficial-redmine.org デモサイト¶

Redmine.org上のチケットplus1数を集計し、検索用に公開しています。( 2022/5 Redmine5.0 リリース記念版)¶