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 #10704 define a query with date fields
Actions
Summary
Empty
define a query with date fields
Empty

This story apply on following fields:

  • submitted_on
  • last_update_date

These are "Always There Fields". Specificities of ATF are described in the epic.

For those fields:

  • Can use =, !=, >, <, >=, <=, BETWEEN
  • Can use NOW() function with operations (+/- x D/M/Y)

Limitations (No relevant use cases to support this):

  • Cannot use empty string
  • Cannot use =, != with NOW()
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
#10704
Manuel Vacelet (vaceletm)
2018-02-28 10:48
2017-09-29 14:18
3283

References
Artifact links
Empty
Referencing story #10704

Artifact Tracker v5

epic #10407 Cross tracker search
rel #10968 9.18

Git commit

tuleap/tuleap/stable

Introduce @submitted_on in xTracker TQL 316c674931
User avatar Yannis ROSSETTO (rossettoy) , 2018-02-20 15:53
@submitted_on is taken into account in the query editor a62692828e
User avatar Yannis ROSSETTO (rossettoy) , 2018-02-21 11:11
Deal with = for @submitted_on a7956b59b1
User avatar Yannis ROSSETTO (rossettoy) , 2018-02-21 12:01
Deal with != for @submitted_on 70f5a45199
User avatar Yannis ROSSETTO (rossettoy) , 2018-02-21 14:06
Refactoring: Extract validation of comparison value 79282994ca
User avatar Nicolas Terray (nterray) , 2018-02-22 10:17
Introduce > for @submitted_on 7aca758a6e
User avatar Nicolas Terray (nterray) , 2018-02-22 10:58
= and != must deal with non date values 0039c782bd
User avatar Yannis ROSSETTO (rossettoy) , 2018-02-22 14:44
Deal with >= for @submitted_on 2642e0a5cd
User avatar Yannis ROSSETTO (rossettoy) , 2018-02-22 16:59
Greater and GreaterEqual share a common abstract class faf0de3717
User avatar Yannis ROSSETTO (rossettoy) , 2018-02-22 17:06
Check that all trackers have a readable subon field ceebb07ff4
User avatar Nicolas Terray (nterray) , 2018-02-23 11:44
Display generic error message instead of silently ignore the error ff112d77c8
User avatar Nicolas Terray (nterray) , 2018-02-23 12:59
Deal with < for @submitted_on f261f647cb
User avatar Yannis ROSSETTO (rossettoy) , 2018-02-23 14:00
Deal with <= for @submitted_on 6c12b8adeb
User avatar Yannis ROSSETTO (rossettoy) , 2018-02-23 14:50
Compare @submitted_on with NOW() 0d84d894d4
User avatar Nicolas Terray (nterray) , 2018-02-23 16:25
Introduce BETWEEN() in cross tracker 20a4958eae
User avatar Nicolas Terray (nterray) , 2018-02-23 17:31
Refactoring: kill InvalidSemantic namespace with ? ebf0b8113b
User avatar Nicolas Terray (nterray) , 2018-02-23 18:04
NOW() et BETWEEN() must be autocompleted feee0a23ac
User avatar Yannis ROSSETTO (rossettoy) , 2018-02-26 10:36
Introduce @last_update_date in cross tracker widget 5c9e066f90
User avatar Nicolas Terray (nterray) , 2018-02-26 16:18
Refactoring: Composition instead of inheritance 5bad42d239
User avatar Nicolas Terray (nterray) , 2018-02-26 16:19
Parameters of from statements should also be unique f234ccf80d
User avatar Nicolas Terray (nterray) , 2018-02-27 12:02
Refactoring: inject DateFormatValidator 4da40ac6b4
User avatar Nicolas Terray (nterray) , 2018-02-27 14:44
Display settings

Follow-ups

User avatar
Nicolas Terray (nterray)2018-02-27 14: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
Nicolas Terray (nterray)2018-02-23 15:16
  • 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