•  
     
    story #8858 query tracker with expressions
Summary
tracker export user
query tracker with expressions
Empty

See proposed UI integration

  • On a tracker report, in search area, I can switch to "Export" mode
  • The expert mode is a simple text area with select box for the fields that can be searched
  • Grammar
    • fields type: string & text
    • operators: (), AND, OR, =
  • The query is save in sessions & in DB (for reuse as report)
  • There is limited error management
  • Technically speaking
    • parse this grammar & generate AST
    • generate SQL from AST
      • manage permissions
      • introduce a limit with the depth of AST (configurable per site) in order to prevent too complex queries
  • Examples:
    • summary="test" and description="stuff"
    • (summary="test" or description="stuff") and free_text="stuff"

 

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
#8858
Manuel Vacelet (vaceletm)
2017-01-04 13:31
2016-02-11 11:19
10011

References

Follow-ups

User avatar
Laurence Terrien (ltn)2016-11-14 13:07
last edited by: Laurence Terrien (ltn) 2016-11-14 13:42

Q1. Could it be possible to have the opérator "not =" (different of) ?

 

Q2. We are asked for searching in the threads area (commentaires), will it be possible ?

 

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
  • 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