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: Optimize query on @status

Download Browse

Part of story #36833 search on semantics and always there fields even if not defined The query built uses many join even in the where, it was not efficient. So replace it with a smaller one inspired by what we've done for list fields. It should take less time to find same artifacts. Also remove a useless join in list field : the join on changeset brings nothing as data is already present in artifact and changeset_value. *No functional changes expected* Note: This commit fix a previous broken one 3235405f177fe9e32a055aab3e7a4bae4aeef5b0 reverted in 25e7d37df1b8d73322e0f01801de3ac515802665 Change-Id: I59e57481d90bb1eca1e09bb9c95a4d47c5f66d30

+57 −98
Kevin Traini (ktraini) 2024-03-25 16:17
Kevin Traini (ktraini) 2024-04-02 15:27
9198151162369a61ea13fcde6b27d753304f7bdd
85e9a5387f5484c5de2ff9fc256117388dec2bf2
git #tuleap/stable/9198151162369a61ea13fcde6b27d753304f7bdd

Modified Files

Side by side diff
Inline diff
Name
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/Field/ListFromWhereBuilder.php +2 −3 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/Metadata/Semantic/Status/StatusFromWhereBuilder.php +25 −95 Go to diff View file
M plugins/crosstracker/tests/integration/CrossTracker/Report/Query/Advanced/Metadata/StatusMetadataTest.php +30 −0 Go to diff View file