User:Cpeterson: Difference between revisions

From MozillaWiki
Jump to navigation Jump to search
(→‎<bugzilla> wiki query syntax: (ISO 8601 datetime string like "2019-01-01"))
(or equals to)
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
= &lt;bugzilla&gt; wiki query syntax =
= &lt;bugzilla&gt; wiki query syntax =


* [https://mana.mozilla.org/wiki/pages/viewpage.action?spaceKey=PM&title=Mind+the+Project+-+August+7%2C+2018#MindtheProjectAugust7,2018-IntroductiontoMozilla%E2%80%99sBugzillaMediaWikiextension Introduction to Mozilla’s Bugzilla MediaWiki extension] (Mind the Project blog post - August 7, 2018)
* Example bug wikis for triaging bugs:
** [https://wiki.mozilla.org/Mobile/GeckoView/Bugs GeckoView bug triage]
** [https://wiki.mozilla.org/Project_Fission/Bugs Fission bug triage]
** [https://wiki.mozilla.org/Mobile/Fennec/Bugs Fennec bug triage and QA workflow]
* [https://github.com/mozilla/mediawiki-bugzilla MediaWiki extension for Bugzilla]
* [https://github.com/mozilla/mediawiki-bugzilla MediaWiki extension for Bugzilla]
* [[Bugzilla:BzAPI:Search|BzAPI search parameters]]
* [[Bugzilla:BzAPI:Search|BzAPI search parameters]]
Line 41: Line 46:
| resolution
| resolution
|-
|-
! Creation time (ISO 8601 datetime string like "2019-01-01")
! Creation time (ISO 8601 datetime string like "2019-01-01" or relative time like "7d")
| creation_ts
| creation_ts
| creation_time
| creation_time
Line 61: Line 66:
| blocks
| blocks
|-
|-
! Last change time (Unix timestamp or ISO 8601 datetime string like "2019-01-01"?)
! Last change time (ISO 8601 datetime string like "2019-01-01" or relative time like "7d")
| delta_ts
| delta_ts
| last_change_time
| last_change_time
Line 85: Line 90:
"---,?,unaffected,affected,fix-optional,fixed,wontfix,verified,disabled,verified-disabled"
"---,?,unaffected,affected,fix-optional,fixed,wontfix,verified,disabled,verified-disabled"
| cf_status_firefox99
| cf_status_firefox99
|-
! needinfo?
| "flagtypes.name" substring "needinfo"
| N/A?
|}
|}


Line 101: Line 110:
! Less than
! Less than
| lessthan
| lessthan
|-
! Less than or equals to
| lessthaneq
|-
|-
! Greater than
! Greater than
| greaterthan
| greaterthan
|-
! Greater than or equals to
| greaterthaneq
|-
|-
! Matching regular expression
! Matching regular expression
Line 158: Line 173:
| changedafter
| changedafter
|}
|}
= Fission Bug Counts By Component =
Bugs by product:
<bugzilla type="count" display="bar">
{
  "f1": "cf_fission_milestone",
  "o1": "nowords",
  "v1": "---,Future",
  "resolution": "---",
  "x_axis_field": "product"
}
</bugzilla>
Core bugs by component (A-E):
<bugzilla type="count" display="bar">
{
  "f1": "cf_fission_milestone",
  "o1": "nowords",
  "v1": "---,Future",
  "f2": "product",
  "o2": "equals",
  "v2": "Core",
  "f3": "component",
  "o3": "lessthan",
  "v3": "E",
  "resolution": "---",
  "x_axis_field": "component"
}
</bugzilla>
Core bugs by component (E-P):
<bugzilla type="count" display="bar">
{
  "f1": "cf_fission_milestone",
  "o1": "nowords",
  "v1": "---,Future",
  "f2": "product",
  "o2": "equals",
  "v2": "Core",
  "f3": "component",
  "o3": "greaterthan",
  "v3": "E",
  "f4": "component",
  "o4": "lessthan",
  "v4": "P",
  "resolution": "---",
  "x_axis_field": "component"
}
</bugzilla>
Core bugs by component (P-Z):
<bugzilla type="count" display="bar">
{
  "f1": "cf_fission_milestone",
  "o1": "nowords",
  "v1": "---,Future",
  "f2": "product",
  "o2": "equals",
  "v2": "Core",
  "f3": "component",
  "o3": "greaterthan",
  "v3": "P",
  "resolution": "---",
  "x_axis_field": "component"
}
</bugzilla>
DevTools bugs by component:
<bugzilla type="count" display="bar">
{
  "f1": "cf_fission_milestone",
  "o1": "nowords",
  "v1": "---,Future",
  "f2": "product",
  "o2": "equals",
  "v2": "DevTools",
  "resolution": "---",
  "x_axis_field": "component"
}
</bugzilla>
Firefox bugs by component:
<bugzilla type="count" display="bar">
{
  "f1": "cf_fission_milestone",
  "o1": "nowords",
  "v1": "---,Future",
  "f2": "product",
  "o2": "equals",
  "v2": "Firefox",
  "resolution": "---",
  "x_axis_field": "component"
}
</bugzilla>

Latest revision as of 22:17, 7 September 2023

<bugzilla> wiki query syntax

Field names:

Bug field Query field Table column

("include_fields")

Assignee assigned_to assigned_to
Comments longdesc N/A?
Bug number bug_id id
Summary/title short_desc summary
Bugzilla component component component
Status (UNCONFIRMED, NEW, ASSIGNED, RESOLVED, VERIFIED, REOPENED) bug_status status
Resolution (FIXED, INVALID, WONTFIX, DUPLICATE, WORKSFORME, INCOMPLETE) resolution resolution
Creation time (ISO 8601 datetime string like "2019-01-01" or relative time like "7d") creation_ts creation_time
Whiteboard string status_whiteboard whiteboard
Keywords keywords keywords
List of dependent blocking bugs dependson depends_on
List of bugs blocked blocked blocks
Last change time (ISO 8601 datetime string like "2019-01-01" or relative time like "7d") delta_ts last_change_time
Platform rep_platform platform
Priority priority priority
Severity bug_severity severity
Ever confirmed? (i.e. status ever NEW or ASSIGNED?) everconfirmed ever_confirmed
status-firefox99 tracking flags cf_status_firefox99

"---,?,unaffected,affected,fix-optional,fixed,wontfix,verified,disabled,verified-disabled"

cf_status_firefox99
needinfo? "flagtypes.name" substring "needinfo" N/A?

Operators for testing field values:

Operator description Operator name
Equals equals
Not equals notequals
Less than lessthan
Less than or equals to lessthaneq
Greater than greaterthan
Greater than or equals to greaterthaneq
Matching regular expression regexp
Not matching regular expression notregexp
is_any (?) anyexact
Contains substring

(case-sensitive!)

casesubstring
Contains substring (case-insensitive) substring
Does not contain substring (case-insensitive) notsubstring
Contains all substrings (list of comma-separated strings) allwordssubstr
Contains any substrings (list of comma-separated strings) anywordssubstr
Does not contain any substrings (list of comma-separated strings) nowordssubstr
Contains all exact words (list of comma-separated strings) allwords
Contains any exact words (list of comma-separated strings) anywords
Does not contain any exact words (list of comma-separated strings) nowords
Changed from changedfrom
Changed to changedto
Changed by (email address?) changedby
Changed before relative time (e.g. 365d, 52w, 1m, or 1y) changedbefore
Changed after relative time (e.g. 365d, 52w, 1m, or 1y) changedafter