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

Do not duplicate results with != OPEN()

Download Browse

Part of story #10702: define a query with status semantic Given a tracker semantic status field with 3 open values and 3 closed values And a closed artifact with title = 'Lorem ipsum' And a closed artifact with title = 'Typo in title' When you cross-tracker-search `@status != OPEN() or @title = 'typo'` Then it should not duplicate artifacts in the results set. It introduce a IN clause, however according to the EXPLAIN, it is the best tradeoff we found to avoid a DISTINCT in the main SELECT. Change-Id: I416bb106ad5f59fc0d15e1fe928c4f099dfde92e

+17 −13
Nicolas Terray (nterray) 2018-02-20 10:58
Nicolas Terray (nterray) 2018-02-20 11:03
0d3514d8e682c1940aedbac37bcc81791c343db3
d6fccc6a1aef11a733f205f816e212e4643eba3e
git #tuleap/stable/0d3514d8e682c1940aedbac37bcc81791c343db3

Modified Files

Side by side diff
Inline diff
Name
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/Semantic/Status/NotEqualComparisonFromWhereBuilder.php +17 −13 Go to diff View file