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* Change-Id: Icf30f6393cca68b83a1e9bfc2a1ba3c151fd079f

+53 −98
Kevin Traini (ktraini) 2024-03-25 16:17
Kevin Traini (ktraini) 2024-03-26 11:11
3235405f177fe9e32a055aab3e7a4bae4aeef5b0
290722ee074c0f3753923edda1dad28aba211ad4
git #tuleap/stable/3235405f177fe9e32a055aab3e7a4bae4aeef5b0

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 +21 −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