Add columns
Added by Peter Kanduma about 13 years ago
Hi
Is it possible to add some columns on the project-view all issues report i.e i would like to add column to show the date when the issue was closed.
Replies (9)
RE: Add columns - Added by Tony Marschall about 13 years ago
I am trying to build a plugin for this feature. Is there a common way to acces issue date for last close?
RE: Add columns - Added by Tony Marschall about 13 years ago
Currently i am using the following sql statement to get the date of first close date:
SELECT journals.created_on, journal_details.value FROM journals, journal_details WHERE journals.journalized_id = _ISSUE_ID_ AND journals.id = journal_details.journal_id AND journal_details.prop_key = 'status_id' AND journal_details.property = 'attr' AND journal_details.value IN (SELECT is_close.id FROM issue_statuses is_close WHERE is_close.is_closed = 1) ORDER BY journals.created_on DESC LIMIT 1,1
Is there a more common ruby / ror way?
RE: Add columns - Added by Tony Marschall about 13 years ago
i have created a redmine plugin: https://github.com/tonymarschall/redmine_closed_column
Maybe this is helpful. Be carefull, its my first ror script and redmine plugin ...
RE: Add columns - Added by Mischa The Evil about 13 years ago
Thanks for sharing this. I'm sure this can be of any help for some users since I've seen requests for such multiple times in the past.
RE: Add columns - Added by Sanjay jain about 13 years ago
Yes, thanks for sharing this. I've been trying to figure out how to spent time sum, and add custom fields as columns to reports.
If you can help in that regard, it would be appreciated by many people.
RE: Add columns - Added by Mischa The Evil about 13 years ago
Sanjay jain wrote:
[...] I've been trying to figure out how to spent time sum, [...]
Particularly for that: see #971, its relatives and the plugins proposed in those issues.
RE: Add columns - Added by Sanjay jain about 13 years ago
Seems like Spent time issue has been around a while...
How about creating a table view that creates a sum of hours on each task. We've been able to do that.... Can we now use that to add a column to the report?
RE: Add columns - Added by Tony Marschall about 13 years ago
I have added time_format for last and first close date + a new count closes column
How can i change init.rb to make columns configurable per project, is this possible without permission like seen in plugin tutorial?