Project

General

Profile

Forums » Plugins »

New useful plugin Redmine eXtended Queries

Added by Jérôme BATAILLE about 4 years ago

Hi,

We have retributed a new Redmine Plugin, that adds a lot of simple enhancements to Queries.
Fell free to test it.

redmine_xtended_queries : https://github.com/Utopism/redmine_xtended_queries

Redmine plugin that adds new Columns, Filters and other features.

How it works

What it does

  • Issue Queries :
  • New Or Filters, like Filters but cumulative (not exclusive).
    With or filters you can for example select issues assigned to you OR that you have created.
  • New columns :
    • Issues Tree :
      • Project of the parent isssue
      • ⊨ Parent task
      • ⊨ Parent task -- (Position)
      • ⊨ Parent task -- (Subject)
      • ⊨ Root task
      • ⊨ Root task -- (Position)
      • ⊨ Root task -- (Subject)
      • ⊨ Position
    • Project Updated
  • The Updated on value
    • Issue Updated on
  • New filters :
    • Project updated
      The Updated on value
    • Filter on Subproject changed : current project not selected by default
      Available if on a project, and having children
      Natively when you filter on Sub-projects, you always have the issues of the current project even if project is not selected.
  • Parent Project (if on a project)
  • If advanced checkbox is checked :
    • Root task (if on a project)
    • Parent task (if on a project)
    • Issue (if on a project)
  • Input field replaced by drop down list if Advanced Filers is checked.
    • Children count
    • Level in tree (0 for root tasks)

To be continued in next message ...


Replies (4)

RE: New useful plugin Redmine eXtended Queries - Added by Jérôme BATAILLE about 4 years ago

  • Time Entry Queries :
    • New columns :
      • Estimated time
      • Tracker + groupable
      • Target version
      • Category + groupable
      • Subject
      • Watchers
      • Issues Tree :
        • ⊨ Issue Id.
        • ⊨ Root task
        • ⊨ Parent task
      • Date :
        • + Year
        • + Month
        • Week + groupable
      • Cumulative Hours :
        • Hours for issue and user
        • Hours for issue
        • Hours for user
        • Hours for issue and user this month
        • Hours for issue this month
        • Hours for user this month
        • Hours for issue and user previous month
        • Hours for issue previous month
        • Hours for user previous month
      • New Cumulative Billable and Deviation :
        Only if Billable and Deviation called Custom Fields exist on Time Entries
  • Billable hours for issue and user
  • Billable hours for issue
  • Billable hours for user
  • Billable hours for issue and user this month
  • Billable hours for issue this month
  • Billable hours for user this month
  • Billable hours for issue and user previous month
  • Billable hours for issue previous month
  • Billable hours for user previous month
  • Deviation hours for issue and user
  • Deviation hours for issue
  • Deviation hours for user
  • Deviation hours for issue and user this month
  • Deviation hours for issue this month
  • Deviation hours for user this month
  • Deviation hours for issue and user previous month
  • Deviation hours for issue previous month
  • Deviation hours for user previous month
  • New Totalable columns :
    • Spent Hours by Issue / User
    • Billable Hours by Issue / User
    • Deviation Hours by Issue / User
  • New Filters :
    • Hours for issue and user
    • Hours for issue
    • Hours for user
  • Hours for issue and user this month
  • Hours for issue this_month
  • Hours for user this month
  • Hours for issue and user previous month
  • Hours for issue previous_month
  • Hours for user previous month
  • New Group totals fixed for
    • Spent Hours by Issue / User
    • Billable Hours by Issue / User
    • Deviation Hours by Issue / User
  • Queries columns selection boxes : new prefix glyphs (utf8) for :
    • Time columns
    • Date type columns
    • Custom Fields
    • Issue tree and position columns
  • Forbid setting global query public to other than me for non-admins : Fixed upstream with Redmine V3.0.4

RE: New useful plugin Redmine eXtended Queries - Added by Jérôme BATAILLE about 4 years ago

Hi, this plugin has been launched in Production in our company, it is in a mature state.

We will continue to make it evolve, so your comments are welcome !

RE: New useful plugin Redmine eXtended Queries - Added by Sérgio Lopes about 4 years ago

Hi,

I'll be installing the plugin in production env at my company, since there are no install instruction I'm assuming it follows the standard pluing installation process. Anything I should keep an eye out for?

Thank you.

RE: New useful plugin Redmine eXtended Queries - Added by Jérôme BATAILLE about 4 years ago

Hi Sérgio, I'm glad you try this plugin.

Yes, it's a standard Redmine plugin.

  • What you have to know is that, you will also have to install the redmine_smile_base plugin :
    https://github.com/Smile-SA/redmine_smile_base.
  • Also a few methods / views are Rewritten by these plugins (see the READMEs), but if you have only a few plugins installed there is very little chance to have conflicts.
    (1-4/4)