Plugins Directory » Redmine Issue Stats Query
|
|
Author: | Yasu Saku |
|---|---|---|
| Website: | https://github.com/sk-ys/redmine_issue_stats_query | |
| Code repository: | https://github.com/sk-ys/redmine_issue_stats_query | |
| Registered on: | 2026-11-15 (2 days ago) | |
| Current version: | 0.1.0 | |
| Compatible with: | Redmine 7.0.x, 6.1.x | |
| User ratings: |
Adds count-based columns, filters and sorting to the issue list:
related issues, comments, issue history, property changes count, attachments, watchers, direct subtasks.
On the issue filter selector, stat filters are grouped under Issue stats.

How it works¶
- Filter / sort: each stat is aggregated in a derived table that is LEFT JOINed only when the filter or sort is used (one row per issue, so result rows are never multiplied).
- Columns: counts for the issues on the current page are loaded in one query per displayed column.
Available stats¶
Each stat is available as a filter, a column and a sort key.
| Stats name | Key | Description |
|---|---|---|
| Attachments count | attachments_count |
files attached to the issue. |
| Comments count | comments_count |
history entries that have a note. |
| Issue history count | journals_count |
history entries that have a note or property changes. |
| Property changes count | property_changes_count |
history entries that have property changes. An entry counts once, however many properties it changes; comment-only entries are not counted. |
| Related issues count | visible_relations_count |
relations, in either direction, to issues the current user can see. |
| Related issues count (total) | total_relations_count |
all relations, in either direction, regardless of visibility. |
| Subtasks count | visible_children_count |
direct subtasks the current user can see. |
| Subtasks count (total) | total_children_count |
all direct subtasks, regardless of visibility. |
| Watchers count | visible_watchers_count |
all watchers if the user may view the watcher list (view_issue_watchers), otherwise only the user's own watch. |
| Watchers count (total) | total_watchers_count |
all watchers, regardless of permissions. |
The total_*_count stats require extra permissions, see below.
Permissions¶
total_*_count stats are controlled by project permissions:
view_total_relations_countview_total_children_countview_total_watchers_count
By default, these total_*_count stats are disabled on global issue list queries (no project context). You can enable each one in plugin settings:
allow_global_total_relations_countallow_global_total_children_countallow_global_total_watchers_count
When enabled, user permission settings are ignored for that total_*_count stat, regardless of whether the issue list is global or project-scoped.
visible_*_count stats are always available and use visibility rules defined by each stat.
comments_count and journals_count are visibility-aware for private notes, so private notes are counted only when the current user is allowed to view them (or is the note author).
Installation notes
- Copy (or clone) this plugin into
plugins/redmine_issue_stats_queryinside your Redmine installation. The directory name must beredmine_issue_stats_query. - Restart Redmine. (No database migration is required.)
- Check that the plugin appears under Administration > Plugins.
- Go to Administration > Plugins > Redmine Issue Stats Query and configure the plugin global permission settings as needed (see "Permissions").
- Grant the permission to the roles that should use the global column and filters (see "Permissions").
Changelog
0.1.0 (2026-11-15)
Compatible with Redmine 7.0.x, 6.1.x.