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

fix: Order by is ran only on one page

Download Browse

Part of story #39685 Order artifact according to a field By doing order by only one page, the order was not correct between pages. For example with @id ASC we could get 21->54 then 5->64 then 30->35 This patch fix this issue by running order by on WHERE and SELECT queries *Testing:* Have more than 60 artifacts (more than 2 pages) and use SELECT @id FROM @project = 'self' WHERE @id >= 1 ORDER BY @id ASC The order of artifact should go ascending and continue on other pages Try the same with DESC Change-Id: I940b593059c7c66f075d72a5a8658dc63b4ef85f

+68 −59
Kevin Traini (ktraini) 2024-09-23 15:18
Kevin Traini (ktraini) 2024-09-23 15:18
8c5e862c0fd0cbddeaa7e2b16041841e15d0b69a
4424646c2793e57bc2ae2d7fdaca38c00c705714
git #tuleap/stable/8c5e862c0fd0cbddeaa7e2b16041841e15d0b69a

Modified Files

Side by side diff
Inline diff
Name
M plugins/crosstracker/include/CrossTracker/Report/CrossTrackerArtifactReportFactory.php +2 −1 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/ArtifactLink/ForwardLinkFromWhereBuilder.php +4 −4 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/ArtifactLink/ReverseLinkFromWhereBuilder.php +4 −4 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/CrossTrackerExpertQueryReportDao.php +33 −25 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/Field/Date/DateFromWhereBuilder.php +1 −1 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/Field/Datetime/DatetimeFromWhereBuilder.php +1 −1 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/Field/ListFromWhereBuilder.php +1 −1 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/Field/Numeric/NumericFromWhereBuilder.php +1 −1 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/Field/Text/TextFromWhereBuilder.php +1 −1 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/Metadata/MetadataFromWhereBuilder.php +5 −5 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/Metadata/Semantic/AssignedTo/AssignedToFromWhereBuilder.php +12 −12 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/Metadata/Semantic/Description/DescriptionFromWhereBuilder.php +2 −2 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/Metadata/Semantic/Status/StatusFromWhereBuilder.php +1 −1 Go to diff View file