Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

stable

Clone or download

Read-only

Artifacts using multi-valued fields should not be shown multiple times in the renderer

Download Browse

To reproduce the issue: 1. Create an artifact with a MSB field and select multiple values 2. Go to the tracker report renderer/Do a CSV export Issue introduced/made visible by 6f69024b5bd0ed5bf020f72e4253b4fe0ab78a2e. It appears the only role of "GROUP BY" was to avoid/workaround this issue. The ONLY_FULL_GROUP_BY SQL mode rightfully complains about it since in any cases the multiple values will need to be fetched independently. Part of request #29628: Run with ONLY_FULL_GROUP_BY SQL mode Change-Id: Iefe80715b7ed64437c98d86dbb78de1c315d10c8

+13 −18
Thomas Gerbet (tgerbet) 2022-12-06 10:33
Thomas Gerbet (tgerbet) 2022-12-06 11:27
096e0002bd63220d0dd7e7d94ad44cd5c4657316
efb9349e7148ba71d80bc505f89f324d9fb067d5
git #tuleap/stable/096e0002bd63220d0dd7e7d94ad44cd5c4657316

Modified Files

Side by side diff
Inline diff
Name
M plugins/tracker/include/Tracker/FormElement/Tracker_FormElement_Field.php +5 −0 Go to diff View file
M plugins/tracker/include/Tracker/FormElement/Tracker_FormElement_Field_List.php +0 −8 Go to diff View file
M plugins/tracker/include/Tracker/FormElement/Tracker_FormElement_Field_MultiSelectbox.php +1 −4 Go to diff View file
M plugins/tracker/include/Tracker/FormElement/Tracker_FormElement_Field_OpenList.php +1 −4 Go to diff View file
M plugins/tracker/include/Tracker/Report/Tracker_Report_Renderer_Table.class.php +1 −1 Go to diff View file
M plugins/tracker/tests/unit/Tracker/Report/TrackerReportRendererTableTest.php +5 −1 Go to diff View file