•  
     
    story #8860 TQL for select box
Summary
Empty
TQL for select box
Empty
  • Grammar
    • New fields: select box, multi select box, radio, check box
      • Search on values label
    • New operator: in()
    • New function: myself()
  • Examples:
    • submitted_by=myself() OR assigned_to=myself()
    • submitted_by = "jmasson" (case insensitive) (!=)
    • submitted_by = "Joris MASSON" (case insensitive) (!=)
    • assigned_to = "" (!=)
    • category in ("Database", "UI") (case insensitive) (not in)
    • support_group = "Project Members" (case insensitive)
Empty
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
#8860
Manuel Vacelet (vaceletm)
2017-03-02 09:13
2016-02-11 11:32
4536

References
Referencing story #8860

Git commit

tuleap/tuleap/stable

status = "" 315c8a281d
status != "" 729110e724
Error message not supported operators (<, between, …) 7389caf118
status = "Open" 7495ff9024
status != "Open" be24f87e32
Check if value exists in list before building query 3556b5fb4b
Error message for radiobutton for <= c2c9403f63
Add support for the NOT IN() operator 71b2fb4e7c
Add an interface for ComparisonVisitor c6937db45c
Checking that field values exists should ignore case 6c865ca1ed
assigned_to = "" a90652a6fa
assigned_to != "" 461740007a
ugroups = "" f70e8ec3cd
assigned_to = "joe" a06c969e63
assigned_to != "joe" afaef264e5
assigned_to IN ("jdoe", "jrem") c76c32a8aa
ugroups != "" b731eb39e0
assigned_to != "joe" e37757ca1e
Refactor the lowercase comparison of values 79d177e1da
assigned_to NOT IN ("jdoe", "jrem") 00e7c59b72
using AND in list comparisons only runs the last comparison fc4bbb98c0
Introduce new function myself() f4a21e7e44
Manage submitted_by b9f9b60152
Manage last_updated_by c87157d43f
Throw list to now comparison exception for IN() and NOT IN() 7ad2f3fb5b
Refactoring: List fields read only 20593cd1d9
Add unit test for list fields bind to users f475cf403b
group = 'Project Members' efcbcffd39
group != 'Project Members' fdffbe0ffa
group IN('Project Members') 1e6187ba65
group NOT IN('Project Members') 7b221beb6c
Take into account user language ecc9d7d277
Add support for all dynamic user groups cc8dd9f1f1
Refactoring: List fields parameters 7513fbd498

Follow-ups

User avatar
Joris MASSON (jmasson)2017-02-23 10:43
Since gerrit #7735 was merged, list fields bound to user groups no longer display "project_members" but instead display "Project members". Therefore, it no longer makes sense to support searching "project_members".

  • 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)2017-02-22 09:52
  • 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
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