User:Cpeterson: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
(Add notes about <bugzilla> table query syntax) |
||
| Line 5: | Line 5: | ||
"f1": "keywords", | "f1": "keywords", | ||
"o1": "anywords", | "o1": "anywords", | ||
"v1": " | "v1": "crashzzz", | ||
"f2": "cf_status_firefox48", | "f2": "cf_status_firefox48", | ||
| Line 19: | Line 19: | ||
} | } | ||
</bugzilla> | </bugzilla> | ||
= <bugzilla> wiki query syntax = | |||
Field names: | |||
{| class="wikitable" | |||
! Bug field | |||
! Query field | |||
! Table column | |||
|- | |||
! Bug number | |||
| bug_id | |||
| id | |||
|- | |||
! Bug title/summary | |||
| short_desc | |||
| summary | |||
|- | |||
! Bug status (UNCONFIRMED, NEW, ASSIGNED, RESOLVED, REOPENED, VERIFIED) | |||
| bug_status | |||
| status | |||
|- | |||
! Bug creation time (Unix timestamp?) | |||
| creation_ts | |||
| creation_time | |||
|- | |||
! Whiteboard string | |||
| status_whiteboard | |||
| whiteboard | |||
|- | |||
! Keywords (string?) | |||
| keywords (?) | |||
| keywords | |||
|- | |||
! List of dependent blocking bugs | |||
| dependson | |||
| depends_on | |||
|- | |||
! List of bugs blocked | |||
| blocked | |||
| 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: | |||
{| class="wikitable" | |||
! 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-insensitive) | |||
| casesubstring | |||
|- | |||
|- | |||
! Contains substring (case-sensitive) | |||
| substring | |||
|- | |||
! Does not contain substring (case-sensitive?) | |||
| 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 (Unix timestamp?) | |||
| changedbefore | |||
|- | |||
! Changed after (Unix timestamp?) | |||
| changedafter | |||
|} | |||
Revision as of 21:54, 20 April 2016
Crash bugs fixed in 48 but not 47
No results.
0 Total; 0 Open (0%); 0 Resolved (0%); 0 Verified (0%);
<bugzilla> wiki query syntax
Field names:
| Bug field | Query field | Table column |
|---|---|---|
| Bug number | bug_id | id |
| Bug title/summary | short_desc | summary |
| Bug status (UNCONFIRMED, NEW, ASSIGNED, RESOLVED, REOPENED, VERIFIED) | bug_status | status |
| Bug creation time (Unix timestamp?) | creation_ts | creation_time |
| Whiteboard string | status_whiteboard | whiteboard |
| Keywords (string?) | keywords (?) | keywords |
| List of dependent blocking bugs | dependson | depends_on |
| List of bugs blocked | blocked | 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-insensitive) |
casesubstring |
| Contains substring (case-sensitive) | substring |
| Does not contain substring (case-sensitive?) | 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 (Unix timestamp?) | changedbefore |
| Changed after (Unix timestamp?) | changedafter |