•  
     
    story #40088 Expert mode is the new default for cross tracker search
Summary
Empty
Expert mode is the new default for cross tracker search
Empty

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 = MY_PROJECTS() WHERE @status = OPEN() AND @assigned_to = MYSELF() ORDER BY @last_update_date DESC

This requires to introduce a new function MY_PROJECTS() 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.

Empty
Empty
Status
Cross tracker search
Done
Development
  • [ ] Does it involves User Interface? 
  • [ ] Are there any mockups?
  • [ ] Are permissions checked?
  • [ ] Does it need Javascript development?
  • [ ] Does it need a forge upgrade bucket?
  • [ ] Does it need to execute things in system events?
  • [ ] Does it impact project creation (templates)?
  • [ ] Is it exploratory?
Empty
Details
#40088
Manuel Vacelet (vaceletm)
2024-11-05 11:31
2024-10-21 10:11
39881

References

Follow-ups

User avatar
Joris MASSON (jmasson)2024-10-29 12:04

Rename MYPROJECTS() -> MY_PROJECTS(). "myself" is a single word in English, "my projects" are two words, so we add an underscore to mimic a space (à la PHP functions).


  • Acceptance criteria
    Something went wrong, the follow up content couldn't be loaded
    Only formatting have been changed, you should switch to markup to see the changes
User avatar
Joris MASSON (jmasson)2024-10-21 10:50
  • Acceptance criteria
    Something went wrong, the follow up content couldn't be loaded
    Only formatting have been changed, you should switch to markup to see the changes