Overview
Cross-tracker search has two modes:
- normal mode with UI selector for trackers and limited support of TQL (only where part).
- expert mode with only the query.
The former is now deprecated and will disappear at some point (a better UI will be built on top of expert mode). It's time to promote expert mode.
New default queries
However, Expert mode doesn't accept empty queries (this lead to an error). We take the opportunity to help users to get a foot on the ladder with default queries.
On project dashboard, the default query is
SELECT @pretty_title, @submitted_by, @last_update_date, @status, @assigned_to FROM @project = 'self' WHERE @status = OPEN() ORDER BY @last_update_date DESC
On personal dashboard, the default query is
SELECT @pretty_title, @submitted_by, @last_update_date, @status FROM @project = MYPROJECTS() WHERE @status = OPEN() AND @assigned_to = MYSELF() ORDER BY @last_update_date DESC
This requires to introduce a new function MYPROJECTS() that returns the list of projects a user is member of (corresponds to "My projects" widget or "My projects" in Switch to view).
For all new Cross-tracker search widgets, Expert mode is used and one of the queries above (depending on the dashboard context) is already saved in the widget right after creation.