Difference between revisions of "User:Ccicalese/Test Queries"

Latest revision as of 20:55, 29 July 2020

Sum of points of all tasks entering Green Done

2019-09-16: 10

2019-09-30: 0

2019-10-14: 25

2019-10-28: 33

2019-11-11: 16

2019-12-02: 37

List of all tasks entering Green Done between 11/11 and 12/2

	Column Entry Date	Points⠉
T232488: "json" type indicator in URL patterns	25 November 2019
T233737: Document MediaWiki integration tests	20 November 2019
T233977: Document REST API interface	2 December 2019	3
T235549: Documentation for public REST API launch	22 November 2019
T235564: Implement Integration Tests for Existing iOS Endpoints	2 December 2019	5
T235567: Investigate Monitoring Kask Availability via Integration Tests	2 December 2019	8
T235666: REST: Add 'from' and 'to' parameters to historycount endpoint.	2 December 2019	2
T236168: Implement basic search endpoint	26 November 2019	3
T236929: Prepare MW REST API to deploy to Production	25 November 2019
T236963: Deploy version 1.10.0 of wikidiff2 to production	2 December 2019	5
T236964: Pass section headers to wikidiff2 to get section header diffs	25 November 2019	3
T237430: Add object caching and PoolCounter to minor edit count endpoint	2 December 2019	3
T237555: Config change to enable MW REST API	12 November 2019
T237562: Curator reads minor flag of a revision	2 December 2019
T237854: Client Developer knows semantic version of API	25 November 2019	3
T238378: Bot edit count endpoint is timing out	25 November 2019
T238380: History edit count endpoint limits are too low	26 November 2019	2
T238846: Prod compare endpoint missing offset object (with from & to keys) on diff items	25 November 2019

@@ Line 1: / Line 1: @@
 {{#datebarchart:
-|data={{#invoke:Reports|greenDoneReport}}
+|data={{#invoke:Reports|greenDoneReport|2019-09-02,2019-09-16,2019-09-30,2019-10-14,2019-10-28,2019-11-11,2019-12-02}}
 |xaxis=Date of Sprint End
 |yaxis=Point Count of Tasks Closed During Sprint
@@ Line 6: / Line 6: @@
 ;Sum of points of all tasks entering Green Done
--09-16: {{#ask: [[Project::Core Platform Team Workboards (Green)]][[Column::Done]][[Column Entry Date::>>2019-09-02]][[Column Entry Date::<2019-09-16]]
+-09-16: {{#ask: [[Project::Platform Team Workboards (Green)]][[Column::Done]][[Column Entry Date::>>2019-09-02]][[Column Entry Date::<2019-09-16]]
   |?-Has subobject.Points
   |format=sum
 }}
--09-30: {{#ask: [[Project::Core Platform Team Workboards (Green)]][[Column::Done]][[Column Entry Date::>>2019-09-16]][[Column Entry Date::<2019-09-30]]
+-09-30: {{#ask: [[Project::Platform Team Workboards (Green)]][[Column::Done]][[Column Entry Date::>>2019-09-16]][[Column Entry Date::<2019-09-30]]
   |?-Has subobject.Points
   |format=sum
 }}
--10-14: {{#ask: [[Project::Core Platform Team Workboards (Green)]][[Column::Done]][[Column Entry Date::>>2019-09-30]][[Column Entry Date::<2019-10-14]]
+-10-14: {{#ask: [[Project::Platform Team Workboards (Green)]][[Column::Done]][[Column Entry Date::>>2019-09-30]][[Column Entry Date::<2019-10-14]]
   |?-Has subobject.Points
   |format=sum
 }}
--10-28: {{#ask: [[Project::Core Platform Team Workboards (Green)]][[Column::Done]][[Column Entry Date::>>2019-10-14]][[Column Entry Date::<2019-11-11]]
+-10-28: {{#ask: [[Project::Platform Team Workboards (Green)]][[Column::Done]][[Column Entry Date::>>2019-10-14]][[Column Entry Date::<2019-11-11]]
   |?-Has subobject.Points
   |format=sum
 }}
--11-11: {{#ask: [[Project::Core Platform Team Workboards (Green)]][[Column::Done]][[Column Entry Date::>>2019-10-28]][[Column Entry Date::<2019-11-11]]
+-11-11: {{#ask: [[Project::Platform Team Workboards (Green)]][[Column::Done]][[Column Entry Date::>>2019-10-28]][[Column Entry Date::<2019-11-11]]
   |?-Has subobject.Points
   |format=sum
 }}
--12-02: {{#ask: [[Project::Core Platform Team Workboards (Green)]][[Column::Done]][[Column Entry Date::>>2019-11-11]][[Column Entry Date::<2019-12-02]]
+-12-02: {{#ask: [[Project::Platform Team Workboards (Green)]][[Column::Done]][[Column Entry Date::>>2019-11-11]][[Column Entry Date::<2019-12-02]]
   |?-Has subobject.Points
   |format=sum
 }}
-;List of all tasks entering Green Done on or after November 20, 2019:
+;List of all tasks entering Green Done between 11/11 and 12/2:
-{{#ask: [[Project::Core Platform Team Workboards (Green)]][[Column::Done]][[Column Entry Date::>November 20, 2019]]
+{{#ask: [[Project::Platform Team Workboards (Green)]][[Column::Done]][[Column Entry Date::>>2019-11-11]][[Column Entry Date::<2019-12-02]]
   |?Column Entry Date
   |?-Has subobject.Points=Points