Plugins Directory » Redmine Queries For Time Report

Author: Jérôme BATAILLE
Code repository:
Registered on: 2019-11-14 (over 4 years ago)
Current version: 1.0.5
Compatible with: Redmine 4.1.x, 4.0.x, 3.4.x
User ratings:   (0)

Redmine plugin that adds Queries to Time Report like Time Entry Queries.

It allows to add such saved queries to My Page

Be careful, because of the nature of Time Report, records count will not be limited to 10 records, unlike other My Page Blocks.

It also allows to add Time Entries List queries to My Page (not enabled natively).

How it is implemented

  • Rewrites the report TimelogController action method
  • Rewrites the following views :
    • To add icons to the query block title
      • /my/blocks/_calendar.html.erb
      • /my/blocks/_documents.html.erb
      • /my/blocks/_issues.erb
      • /my/blocks/_news.html.erb
      • /my/blocks/_timelog.html.erb
    • To add the project in the query block title
      • /my/blocks/_issue_query_selection.html.erb
  • Adds / Rewrites the following My Page block views
    • /my/blocks/partials/_timelogs.html.erb
    • /my/blocks/partials/_timereport.html.erb
  • Adds My Page block views helper partials :
    • /my/blocks/partials/_timelog_query_selection.html.erb
    • /my/blocks/partials/_timereport_query_selection.html.erb
  • Adds new TimeReportQuery model
  • Extends My Helper by adding the methods :
    • render_timelogquery_block
    • render_timereportquery_block
  • Extends Timelog Helper by adding the methods :
    • prepare_report_object
    • time_entry_scope
  • Extends Redmine::MyPage to :
    • Add new My Page blocks in the CORE_BLOCKS hash
    • Override additional_blocks class method to manage partials overridden in plugins

Installation notes

  • This plugin has no dependency
  • No migration ! uses Single table inheritance Redmine model
  • No new route !
  • Be careful with the plugin folder directory, it must be exactly the plugin name


1.0.5 (2020-02-02)

Compatible with Redmine 4.1.x, 4.0.x, 3.4.x.

  • Time Report Queries : Criteria selection at the beginning in the form

1.0.4 (2020-02-02)

Compatible with Redmine 4.1.x, 4.0.x, 3.4.x.

  • available_criteria_options : sorted criteria + prefix by glyphs icons
  • sql_for_issue_id_field fixed for multiple values

1.0.3 (2020-01-29)

Compatible with Redmine 4.1.x, 4.0.x, 3.4.x.

  • Enabled UserCustomField Criteria
  • Redmine 3.4.3 minimun
  • or_filters replaced by or_filters_provided? because the database column can exist but not the plugin
  • Merge commit '9e6d025'

1.0.2 (2019-12-20)

Compatible with Redmine 4.1.x, 4.0.x.

Incorporate optional enhancements from redmine_extended_queries plugin,
because these two plugins rewrite the same views :
  • Budget And Remaining feature
    • Liste demandes : total F / G / D au niveau de chaque groupe
    • Demandes, Rapport, case à cocher sommer les temps
    • champ de saisie du nombre d'heures par jour
    • Demandes : Export Csv + Pdf, conversion en jours
    • Liste des demandes : conversion jours comme dans le rapport
  • Requête personnalisée : Filtres avancés (Demande, Parent, Racine)
  • Filtre additifs
  • Rapport : case à cocher Tracker
  • Rendre la case "sans les sous-tâches" optionnelle
  • Sauvegarder la case à cocher "Include sub-tasks time"
  • Show issue query owner for Admins
  • Désactivation des rôles obsolètes lors de l'ajout d'un membre dans un projet
  • Sauvegarder la case à cocher "Include sub-tasks time"
  • Forbid setting query public to others than me for non-admins

1.0.1 (2019-11-15)

Compatible with Redmine 4.1.x, 4.0.x.