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.

stable

Clone or download

Read-only

Introduce BETWEEN() in cross tracker

Download Browse

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

+260 −11
Nicolas Terray (nterray) 2018-02-23 17:24
Nicolas Terray (nterray) 2018-02-23 17:31
20a4958eae68d4fe381ecdb3b57dd9730eef8778
0d84d894d497874dc04a8dde9a53de8b09de3187
git #tuleap/stable/20a4958eae68d4fe381ecdb3b57dd9730eef8778

Modified Files

Side by side diff
Inline diff
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