Changes between Version 15 and Version 16 of TicketQuery

Timestamp:

Feb 26, 2017, 9:56:23 AM (7 years ago)

Author:

anonymous

Comment:

Examples for and, or, not.

TicketQuery

@@ -59 +59 @@
 || **[[TicketQuery(created=thismonth..,count)]]**||\
 || `[[TicketQuery(created=thismonth..,count)]]` ||
+|-----------------------------------------------------------
+||=Number of closed Firefox tickets: =||\
+|| **[[TicketQuery(status=closed,keywords~=firefox,count)]]**||\
+|| `[[TicketQuery(status=closed,keywords~=firefox,count)]]` ||
+|-----------------------------------------------------------
+||=Number of closed Opera tickets: =||\
+|| **[[TicketQuery(status=closed,keywords~=opera,count)]]**||\
+|| `[[TicketQuery(status=closed,keywords~=opera,count)]]` ||
+|-----------------------------------------------------------
+||=Number of closed tickets affecting Firefox and Opera: =||\
+|| **[[TicketQuery(status=closed,keywords~=firefox opera,count)]]**||\
+|| `[[TicketQuery(status=closed,keywords~=firefox opera,count)]]` ||
+|-----------------------------------------------------------
+||=Number of closed tickets affecting Firefox or Opera: =||\
+|| **[[TicketQuery(status=closed,keywords~=firefox|opera,count)]]**||\
+|| `[[TicketQuery(status=closed,keywords~=firefox|opera,count)]]` ||
+|-----------------------------------------------------------
+||=Number of tickets that affect Firefox or are closed and affect Opera: =||\
+|| **[[TicketQuery(keywords~=firefox,or,status=closed,keywords~=opera,count)]]**||\
+|| `[[TicketQuery(status=closed,keywords~=opera,or,keywords~=firefox,count)]]` ||
+|-----------------------------------------------------------
+||=Number of closed Firefox tickets that don't affect Opera: =||\
+|| **[[TicketQuery(status=closed,keywords~=firefox - opera,count)]]**||\
+|| `[[TicketQuery(status=closed,keywords~=firefox -opera,count)]]` ||
 |-----------------------------------------------------------
 ||=Last 3 modified tickets: =||\