Plugins Directory » Extra query operators plugin

Author: Vitaly Klimov
Website: http://www.redmine.org/boards/3/topics/21015
Code repository: -
Registered on: 2011-02-14 (almost 7 years ago)
Current version: 0.1.1
Compatible with: Redmine 1.3.x, 1.4.x, 2.0.x
User ratings:   (0)

Redmine extra query operators plugin

Plugin adds extra operators to issues query, allowing to select exact dates and offsets from current date. Also this plugin adds ability to use regular expressions in text fields

Following extra operators are available for all date fields (start date, due date, etc):

  • Between
    Includes all dates which are between specified two dates
  • After
    Includes all dates which are after specified date
  • Before
    Includes all dates which are before specified date
  • Is months
    Includes all dates which are within given month (you may use negative numbers for past months, for example -1 means previous month, etc)
  • Is weeks
    Includes all dates which are within given week (you may use negative numbers for past weeks, for example -1 means previous week, etc)

Following extra operator is available for all string and text fields:

  • Matches regexp
    Searches string using SQL regular expression (ie use \[.*\] in subject filter to find all subjects with square brackets)

Extra syntax for operators before and after

It is possible to define data range relative to current day for before and after operators. For this use following syntax:

(+|-)<number>[w|m]

  • w - weeks from current date
  • m - months from current date

For example, expression +0w in due date filter will show all issues with due date before the monday of next week

Compatibility

Plugin patches views\queries\_filters.html.erb view. Additions are marked with VVK start and VVK end comments

Installation notes

  1. Install plugin Plugin views with revisions if you do not have it installed
  2. Follow the Redmine plugin installation steps
  3. Run rake task
    rake redmine:plugins:process_version_change RAILS_ENV=production
  4. Restart your Redmine web servers (e.g. mongrel, thin, mod_rails)

Changelog

0.1.1 (2012-06-25)

Compatible with Redmine 1.3.x, 1.4.x, 2.0.x.

  • Rails 3 (Redmine 2.x) compatibility

redmine_extra_query_operators_v011.zip (17 KB) Vitaly Klimov, 2012-06-25 15:51

0.1.0 (2012-06-07)

Compatible with Redmine 1.3.x, 1.4.x, 2.0.x.

redmine_extra_query_operators_v010.zip (16.6 KB) Vitaly Klimov, 2012-06-07 18:30

0.0.6 (2012-03-26)

Compatible with Redmine 1.3.x.

  • Bugfixes for start before/after filter

redmine_extra_query_operators_v006.zip (13.9 KB) Vitaly Klimov, 2012-03-26 09:16

0.0.5 (2012-02-23)

Compatible with Redmine 1.3.x.

  • Redmine 1.3.x compatibility
  • Not compatible with Redmine versions prior to 1.3.x
  • Extra syntax for before and after operators implemented (see above)

redmine_extra_query_operators_v005.zip - Version 0.0.5 (13.9 KB) Vitaly Klimov, 2012-02-23 13:58

0.0.4 (2011-07-25)

Compatible with Redmine 1.2.x.

  • Compatibility with Redmine 1.2.x
  • Not compatible with Redmine versions prior to 1.2.x

redmine_extra_query_operators_v004.zip - Version 0.0.4 of plugin (14 KB) Vitaly Klimov, 2011-07-25 17:15

0.0.3 (2011-02-14)

Compatible with Redmine 1.1.x, 1.2.x.

redmine_extra_query_operators_v003.zip - v 0.0.3 (14 KB) Vitaly Klimov, 2011-02-14 11:45