Skip to main content

Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

  •  
     
    story #8859 TQL search on date & numeric fields
Actions
Summary
Empty
TQL search on date & numeric fields
Empty
  • Grammar
    • New fields: date, date time, float, int
      • For date & time: user format already defined in tracker
    • New operators: >, >=, !=, <=, <, between()
    • New function: now() + period. (eg now() - 1w, now() + 2d)
  • Support TQL in REST search
  • Store request elapsed time
  • Add end user doc
  • Examples
    • close_date < now() - 1w
    • create_date > "2015-01-01"
    • estimated_effort between (3, 8)
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
#8859
Manuel Vacelet (vaceletm)
2017-02-01 13:16
2016-02-11 11:29
4568

References
Artifact links
Empty
Referencing story #8859

Artifact Tracker v5

epic #8857 Tuleap Query Language
rel #9810 9.4

Git commit

tuleap/tuleap/stable

API REST 65c3784cc7
User avatar Juliana Leclaire (juliana) , 2017-01-10 13:57
Refactoring: do not pollute Grammar namespace e30f5db6ed
User avatar Nicolas Terray (nterray) , 2017-01-10 20:29
Refactoring: rename Comparison to EqualComparison 9097ff8cd0
User avatar Nicolas Terray (nterray) , 2017-01-10 20:30
Refactoring: FromElement returns directly a FrowWhere object 4dc41e468f
User avatar Juliana Leclaire (juliana) , 2017-01-11 16:09
Numeric is allowed and returns a FrowWhere a9b9a8e68a
User avatar Juliana Leclaire (juliana) , 2017-01-12 09:43
Sort alphabetically field names in TQL facilitators 9fb4004a55
User avatar Nicolas Terray (nterray) , 2017-01-13 15:58
Introduce != 44e394d563
User avatar Juliana Leclaire (juliana) , 2017-01-13 17:13
same behavior between int/float/string for empty value 7c8c7313b2
User avatar Nicolas Terray (nterray) , 2017-01-16 11:13
Refactoring: Do not rely on instance_of operator d8b3379728
User avatar Nicolas Terray (nterray) , 2017-01-16 11:26
Introduce < (only numeric) 1067be5f8a
User avatar Juliana Leclaire (juliana) , 2017-01-16 15:06
Introduce > (only numeric) 716003267e
User avatar Juliana Leclaire (juliana) , 2017-01-16 16:31
Introduce <= 986ffece21
User avatar Juliana Leclaire (juliana) , 2017-01-16 16:34
Introduce >= 878c81dd64
User avatar Juliana Leclaire (juliana) , 2017-01-17 09:57
Refacto: set Comparison value in object c4088e597e
User avatar Juliana Leclaire (juliana) , 2017-01-17 12:14
Enhance error message for unsupported comparisons edc658237a
User avatar Joris MASSON (jmasson) , 2017-01-17 12:13
Refactoring: return Value object instead of string a4fe39d657
User avatar Nicolas Terray (nterray) , 2017-01-17 14:15
Fix unit tests 3b95f20590
User avatar Nicolas Terray (nterray) , 2017-01-18 14:14
Better error messages bde2de2c41
User avatar Nicolas Terray (nterray) , 2017-01-18 14:57
Introduce between() a1c8705dee
User avatar Juliana Leclaire (juliana) , 2017-01-18 15:09
BETWEEN operator is autocompleted 58e285d511
User avatar Nicolas Terray (nterray) , 2017-01-18 16:48
Refactoring: Avoid ->getValue()->getValue() a48d8498a2
User avatar Nicolas Terray (nterray) , 2017-01-19 09:10
Refactoring: rename exception to avoid confusion e9a87cfbf6
User avatar Nicolas Terray (nterray) , 2017-01-19 09:11
Date, submitted_on and last_update_on fields are supported e7fede333a
User avatar Joris MASSON (jmasson) , 2017-01-19 10:29
Introduce =now() 9ce026764c
User avatar Juliana Leclaire (juliana) , 2017-01-20 15:25
Introduce period (+/- 1d) 1a009a39f6
User avatar Juliana Leclaire (juliana) , 2017-01-23 15:32
Fix empty string comparisons 864c0f74f6
User avatar Joris MASSON (jmasson) , 2017-01-23 15:36
Manage all periods usable with now 3a792e7aa2
User avatar Juliana Leclaire (juliana) , 2017-01-24 10:34
Add NOW() in autocomplete 250c5607a4
User avatar Juliana Leclaire (juliana) , 2017-01-24 11:30
Add syntax highlight for now and between b07f2c098b
User avatar Juliana Leclaire (juliana) , 2017-01-24 12:16
Better distinguish now/between and logical operators 8966d19734
User avatar Nicolas Terray (nterray) , 2017-01-24 13:41
Introduce greater than operator for date fields c13c523919
User avatar Joris MASSON (jmasson) , 2017-01-24 13:26
Add syntax highlight for time periods and numbers 903b988b6d
User avatar Nicolas Terray (nterray) , 2017-01-24 14:24
Introduce lesser than operator for date fields 9493749730
User avatar Joris MASSON (jmasson) , 2017-01-24 15:03
Greater than should compare to ceiled date b4b703d1e7
User avatar Joris MASSON (jmasson) , 2017-01-24 15:07
Introduce between for date fields 5573c2f914
User avatar Juliana Leclaire (juliana) , 2017-01-24 16:26
Introduce lesser than or equal operator for date fields c7c18191e6
User avatar Joris MASSON (jmasson) , 2017-01-24 17:09
Introduce greater than or equal operator for date fields 5542442f02
User avatar Joris MASSON (jmasson) , 2017-01-24 18:09
Introduce != for date fields 787af15e11
User avatar Juliana Leclaire (juliana) , 2017-01-25 12:26
When invalid date format, error msg says empty value 60de5fe76c
User avatar Juliana Leclaire (juliana) , 2017-01-25 09:30
Refactoring BetweenComparison query builders 021834c00e
User avatar Juliana Leclaire (juliana) , 2017-01-25 15:38
Refactoring EqualComparison and NotEqualComparison query builders de1c6779f9
User avatar Juliana Leclaire (juliana) , 2017-01-25 16:21
Refactoring LesserThanComparison and LesserThanOrEqualComparison query builders b59f695d86
User avatar Juliana Leclaire (juliana) , 2017-01-25 16:51
Refactoring GreaterThanComparison and GreaterThanOrEqualComparison query builders 0bcc9a992a
User avatar Juliana Leclaire (juliana) , 2017-01-25 16:47
NOW() cannot be compared to int/float/text fields b6f3babe1b
User avatar Nicolas Terray (nterray) , 2017-01-26 14:47
Refacto: Move int/float/date/text in their own namespace c1da4477ce
User avatar Nicolas Terray (nterray) , 2017-01-26 15:56
Refacto: Use a dedicated class to embrace DATE/TIME format 29e8b77d6c
User avatar Nicolas Terray (nterray) , 2017-01-26 15:59
Refacto: Get the values in BETWEEN() in a dedicated object b7eedf2de2
User avatar Nicolas Terray (nterray) , 2017-01-26 16:33
Refacto: check dates in a dedicated object 0c6766a290
User avatar Nicolas Terray (nterray) , 2017-01-26 17:12
Refacto: extract/check date in a dedicated object e6d7329b7f
User avatar Nicolas Terray (nterray) , 2017-01-26 17:48
Refacto: simplify date validation d8714a1884
User avatar Nicolas Terray (nterray) , 2017-01-26 21:31
Refacto: simplify integer/float validation 77b4be828c
User avatar Nicolas Terray (nterray) , 2017-01-26 22:18
Refacto: date condition in a dedicated object a9cb9552c3
User avatar Nicolas Terray (nterray) , 2017-01-27 14:58
Refactoring: Add date read only conditionn in dedicated object bbefd6f7c2
User avatar Juliana Leclaire (juliana) , 2017-01-30 16:56
Display settings

Follow-ups

User avatar
Manuel Vacelet (vaceletm)2016-02-11 11:42
  • 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