•  
     
    story #10678 define a query for title and description semantics
Summary
Empty
define a query for title and description semantics
Empty

Behaviour

By default, the widget execute the hardcoded query but one can edit the query to run it's own.

  • If the query is empty the default query (everything that is open) is executed
  • If the textarea is not empty, its content is interpreted as the query

The columns are still the same as well as the order of the result.

The query is written in TQL, using code mirror with autocompletion and the list of accepted field is available on the right hand side (like expert mode in trackers).

For this story, only "title" and "description" semantics are usable. A query like: title = "foo" will return all artifacts who's title semantic match "foo".

Unlike TQL in the trackers, at this point, TQL search on semantics, not on field names. To avoid any confusion, the initial Runtime Check (see art #10677) will report an error if:

  • There is a field called "title" in one of the tracker and this field is not attached to "title" semantic
  • At least one tracker doesn't have a "title" semantic defined

Same applies for "description" accordingly.

The TQL search must met the "expression limit" defined by site administrator to avoid too complex queries

Technical

  • The grammar defined for TQL can be kept
  • Need to implement a new Tree Verification
  • Need to implement a new Query Generation
  • Warning: how to properly manage errors between Restler and JS
Empty
Status
Empty
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
#10678
Manuel Vacelet (vaceletm)
2018-01-02 17:19
2017-09-21 14:20
4472

References
Referencing story #10678

Git commit

tuleap/tuleap/stable

Add query to GET /cross_tracker_reports/{id}/content 35509a5c7f
Have a textarea in the Write mode of the widget 7816dff859
Validate a query with title semantic and = comparison 87103e8477
Build a query with title semantic and = comparison 04f29164d3
DRY with validation of expert query 4c338f2fbb
title semantic and != comparison 623a1e5982
Save query xtracker report (update REST API) 07ec307675
Allow to search on @description 45ffc74c4a
Refactoring: DRY building of AND/OR queries 59be13a571
Refactoring: introduce interface on top of FromWhere bfef916c6c
Multiple @description in expert query a6afc52a6e
Have babel-polyfill loaded by FlamingParrot 8151ef2a6a
Save the query while clicking on save 9ca1b54a11
Build plugin component dependencies in order 14f5d25a2f
Query form is prefilled by the saved query 0ddb9f53b5
Refactoring: delegate collection of errrors bd5aff38d0
Extract common CodeMirror code from tracker c15cb28acc
Fix saving the report d5d93aec3e
Reject query when one tracker does not use a semantic d10c0fd990
Consistency in text field checks 0713141cdf
Migrate tracker list in reading mode to Vue 52feaf450c
@comment => @comments in error messages 2820fdeea8
Fix saving the report bis d6df8954c7
Create basic REST test b7da4b56be
Migrate Writing mode controller to Vue ac7c7a964d
Add codemirror with autocomplete e15c9aea9b
Display query in reading mode cdc19ed37e
Display artifacts table in writing mode a912e85849
Revision cross-tracker css files 093b97341b
Add cross-tracker unit tests to CI build f5d3607dcc
Fix Tracker and CrossTracker TQL for IE11 63db73fb9d
Add REST tests 768f82270e
Cannot save multiple times a report without reloading the page cc23f9a439
Fix sync between codemirror and writing report 76ede9546e

Follow-ups

User avatar
  • 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
User avatar
Marine Pieux (nynoe)2017-09-29 12:33
  • Attachments 1-widget-multi-trackers-search-dropdown-columns.png, 2-widget-multi-trackers-search-hover.png, 3-widget-multi-trackers-search-edit.png, 4-widget-multi-trackers-search-save-report.png removed
User avatar
Marine Pieux (nynoe)2017-09-29 12:20
  • 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
  • Attachments 1-widget-multi-trackers-search-dropdown-columns.png, 2-widget-multi-trackers-search-hover.png, 3-widget-multi-trackers-search-edit.png, 4-widget-multi-trackers-search-save-report.png added
  • Permissions set to