Redmine

Not with a stock Redmine.

I am trying to build a plugin for this feature. Is there a common way to acces issue date for last close?

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?

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

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.

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.

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.

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?

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?