User:Cpeterson

From MozillaWiki
Jump to: navigation, search

<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