Feature #1043


"My Calendar" page to show assigned items (patch incl)

Added by Carl Nygard over 16 years ago. Updated almost 9 years ago.

Target version:
Start date:
Due date:
% Done:


Estimated time:


I think it would be good to have a "My Calendar" view similar to the project's Calendar (next to Gantt) that shows only the issues assigned to the user. The project Calendar shows info specific to the project, and the My Page Calendar snipped shows all issues in all projects. The new "My Calendar" page serves information not provided any other way.

BTW, I only added the translation to the en.yml file. Didn't know how that should be handled in all the other files.


redmine-my-calendar.patch (3.31 KB) redmine-my-calendar.patch Carl Nygard, 2008-04-11 21:24
calendar.rhtml (2.06 KB) calendar.rhtml Carl Nygard, 2008-04-11 21:25 (12.1 KB) My Calendar packaged as a plugin Peter Van den Bosch, 2008-07-22 23:57
Actions #1

Updated by Carl Nygard over 16 years ago

Here's the rhtml file for implementing the calendar page

Actions #2

Updated by Jean-Philippe Lang about 16 years ago

  • Target version deleted (0.7)

Thanks Carl. I'll try to modify the plugin API so that adding a new block for My page can be done without modifying MyController.

Actions #3

Updated by Peter Van den Bosch about 16 years ago

Hi Carl,

Thanks for the patch. Have been using it and it works great.
I've made use of Jean-Philippe's improvements to the plugin API in trunk and packaged your patch as a plugin, ready for unzipping under {$Redmine}/vendor/plugins.
I also added the versions of the current user's projects in the calendar.

To be in check with the legal stuff: is the GPL license okay for you? Also okay to publish the plugin somewhere (e.g.

Actions #4

Updated by Carl Nygard almost 16 years ago

Sorry, didn't notice the comment.

Yes, GPL is ok. Publish the plugin is ok. Just give proper credit for the work.

Actions #5

Updated by Andrea Maleci almost 16 years ago

I've found a bug on my_calendar plugin.

If an user is not involved on any project (e.g. admin), if you click on my_calendar link you get an internal error.

Mysql::Error: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')))' 
at line 1: SELECT `versions`.`id` AS t0_r0, `versions`.`project_id` AS t0_r1, `versions`.`name` AS t0_r2,
`versions`.`description` AS t0_r3, `versions`.`effective_date` AS t0_r4, `versions`.`created_on` AS t0_r5,
`versions`.`updated_on` AS t0_r6, `versions`.`wiki_page_title` AS t0_r7, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3,
`projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`projects_count` AS t1_r6, `projects`.`created_on` AS t1_r7, `projects`.`updated_on` AS t1_r8, `projects`.`identifier` AS t1_r9,
`projects`.`status` AS t1_r10 FROM `versions`  LEFT OUTER JOIN `projects` ON `projects`.id =
`versions`.project_id   WHERE ((effective_date BETWEEN '2008-07-27' AND '2008-09-06') and (project_id IN ()))

That's because project_id IN () is not a valid SQL statement.

I suppose that Problem is on vendor/plugins/my_calendar/app/controllers/calendar_controller.rb, where retrieve_selected_tracker_ids, for not involved users, does not find anything.

Should be nice that:

  • If the user is not involved on any project will be diplayed an empty calendar (or link is not displayed);
  • (optional) If the user is admin, all Issues an Versions will be displayed.

By the way it's a useful plugin and i hope it become an official plugin asap.


Actions #6

Updated by Peter Van den Bosch almost 16 years ago

oops, forget to watch this issue. Just noticed the new comments last week.

Carl, thanks for your positive response. I've published the plugin on redmine hacks . If interested, I can add you to the project.

A first version is downloadable here

Andrea, the issue you discovered should be fixed now. Thanks for noticing. About the admin's projects scope to all projects: I think this shouldn't be default because an admin can act as a regular user too (i.e. he can be member of some projects but not all). On the other hand, adding a checkbox which sets the scope to all viewable projects for all users seems more interesting to me. I've added this as feature request # 6 at redmine hacks and will look into it.

Actions #7

Updated by Matt Gillette over 15 years ago

This is no longer available at Redmine Hacks:

Does anyone have a mirror location of the most up-to-date version of the plugin?

Actions #8

Updated by Matt Gillette almost 15 years ago

Just wondering if this has gotten anywhere... Eric?

Actions #9

Updated by Dipan Mehta over 11 years ago

+1. Very important feature.


Also available in: Atom PDF