<bugzilla> wiki query syntax
Field names:
| Bug field | Query field | Table column |
|---|---|---|
| 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 (Unix timestamp) | creation_ts | creation_time |
| Whiteboard string | status_whiteboard | whiteboard |
| Keywords | keywords | keywords |
| List of dependent blocking bugs | dependson | depends_on |
| List of bugs blocked | blocks | blocks |
| Last change time (Unix timestamp) | delta_ts | last_change_time |
| Platform | rep_platform | platform |
| Severity | bug_severity | severity |
| Ever confirmed? (i.e. status ever NEW or ASSIGNED?) | everconfirmed | ever_confirmed |
Operators for testing field values:
| Operator description | Operator name |
|---|---|
| Equals | equals |
| Not equals | notequals |
| Less than | lessthan |
| Greater than | greaterthan |
| 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 (duration: 1d, 2w, 3m, 4y) | changedbefore |
| Changed after (duration: 1d, 2w, 3m, 4y) | changedafter |