Project

General

Profile

Actions

Defect #35115

closed

Time entries are broken if grouped by project and issue custom fields

Added by Alexander Meindl over 3 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Custom fields
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed
Affected version:

Description

If you have a custom field for project, which can be used for group by filter (e.g. a list format).

If you try to use this custom fields for group by on time entries this throw an exception:

Query::StatementInvalid: Mysql2::Error: Unknown column 'cf_14.value' in 'field list': SELECT COUNT(DISTINCT `time_entries`.`id`) AS count_

This error occurs on project scope and without project scope.

What I found out, till now:

  • this is new with Redmine 4.2
  • with earlier Redmine versions, you cannot select a group by field from other entities implementation

I see the following solutions:

  • allow group by on custom fields from other entities and this error (it looks like the join to custom field is missing)
  • do not offer group by fields of custom fields from other entities

My test environment:

  • Redmine 4.2.0
  • Ruby 2.7.3
  • PostgreSQL 13
  • No plugin

Files


Related issues

Related to Redmine - Defect #33290: Unnecessary database access when IssueQuery class is definedClosedGo MAEDA

Actions
Actions

Also available in: Atom PDF