stable

Clone or download

Read-only

Introduce BETWEEN() in cross tracker

This is part of story #10704 define a query with date fields BETWEEN() can only be used with @submitted_on BETWEEN() accepts only dates and NOW() (+period) You can search for example all artifacts that are submitted this year: @submitted_on BETWEEN('2018-01-01', NOW()) Or all artifacts that have been submitted last year: @submitted_on BETWEEN('2017-01-01', '2018-12-31') Or all artifactsthat have been submitted during the previous week: @submitted_on BETWEEN(NOW() - 2w, NOW() - 1w) … Change-Id: I3c58368f3e42a6780e0b956a03dd778bcc77c489

Modified Files

Name
M plugins/crosstracker/include/CrossTracker/REST/v1/CrossTrackerReportsResource.php +9 −1 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/InvalidComparisonCollectorVisitor.php +14 −2 Go to diff View file
A plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/InvalidSemantic/BetweenComparisonChecker.php +59 −0 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/InvalidSemantic/ComparisonChecker.php +1 −1 Go to diff View file
A plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/Metadata/AlwaysThereField/SubmittedOn/BetweenComparisonFromWhereBuilder.php +82 −0 Go to diff View file
A plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/Metadata/BetweenComparisonFromWhereBuilder.php +51 −0 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilderVisitor.php +19 −4 Go to diff View file
M plugins/crosstracker/include/autoload.php +5 −2 Go to diff View file
M plugins/tracker/include/Tracker/Report/Query/Advanced/InvalidFields/Date/DateFormatValidator.php +1 −1 Go to diff View file
M plugins/tracker/include/Tracker/Report/Query/Advanced/InvalidFields/Date/DateToStringException.php +19 −0 Go to diff View file