•  
     
    story #10704 define a query with date fields
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
3277

References
Referencing story #10704

Git commit

tuleap/tuleap/stable

Introduce @submitted_on in xTracker TQL 316c674931
@submitted_on is taken into account in the query editor a62692828e
Deal with = for @submitted_on a7956b59b1
Deal with != for @submitted_on 70f5a45199
Refactoring: Extract validation of comparison value 79282994ca
Introduce > for @submitted_on 7aca758a6e
= and != must deal with non date values 0039c782bd
Deal with >= for @submitted_on 2642e0a5cd
Greater and GreaterEqual share a common abstract class faf0de3717
Check that all trackers have a readable subon field ceebb07ff4
Display generic error message instead of silently ignore the error ff112d77c8
Deal with < for @submitted_on f261f647cb
Deal with <= for @submitted_on 6c12b8adeb
Compare @submitted_on with NOW() 0d84d894d4
Introduce BETWEEN() in cross tracker 20a4958eae
Refactoring: kill InvalidSemantic namespace with ? ebf0b8113b
NOW() et BETWEEN() must be autocompleted feee0a23ac
Introduce @last_update_date in cross tracker widget 5c9e066f90
Refactoring: Composition instead of inheritance 5bad42d239
Parameters of from statements should also be unique f234ccf80d
Refactoring: inject DateFormatValidator 4da40ac6b4

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