Cross tracker search behavior doesn't change by default. The current default (as per Tuleap 15.10) is called "Legacy" and covers fixed set of columns, the manual selection of trackers and the extension of field search already implemented in initial cross tracker search epic #10407. The format SELECT ... FROM ... WHERE ... ORDER BY ...
is not supported in Legacy mode. Legacy mode only supports the WHERE
part.
It's however possible to switch to "Advanced" mode where everything is under TQL control :
- Selection of columns
- Selection of trackers
- Selection of search criteria
- Selection of sort
It's possible to switch from Advanced to Legacy and vice-versa. Switching to another mode reset the search (there is a warning to inform users).
When Switching to Advanced, there is a default query that is proposed to help users to start SELECT @id, @tracker.name, @title, @status FROM @project = 'self' WHERE @status = OPEN()