This is an old revision of the document!
Search Queries
Some of the bugzilla search queries below are visible and linked on the FreeBSD Bugzilla Dashboard.
Product Searches
-
- … in Base System (215 on 2020-07-09, 229 on 2023-10-19 ⏶)
- … in Ports & Packages (39 on 2020-07-09, 35 on 2023-10-19 ⏷)
- All Issues (9857 before the bugathon on 2020-07-11, 9750 on 2020-07-12 afterwards, “overflow” on 2020-11-15)
- All Base System (7056 on 2021-06-11, 7488 on 2023-10-19 ⏶)
- all Community (1 on 2021-06-11, 3 on 2023-10-19 ⏶)
- all Documentation (490 on 2021-06-11, 606 on 2023-10-19 ⏶)
- all Ports & Packages (2543 on 2021-06-11, 3083 on 2023-10-19 ⏶)
- all Security (13 on 2021-06-11, 2 on 2023-10-19 ⏷)
- all Services (137 on 2021-06-11, 163 on 2023-10-19 ⏶)
- [imputed actual total 2021-06-11: 10240]
Base System
- Base System: All (6830 on 2020-07-09, 6810 on 2020-11-15)
- Base System with Attachments …
- … named either diff or patch (1402 on 2020-07-25)
- Base System with Keyword: needs-patch (69 on 2020-09-13)
- Base System by Status
- New (3188 on 2021-05-07)
- Open (3602 on 2021-05-07)
- In Progress (247 on 2021-05-07)
- (See Also: Notes about Base System/In Progress)
Ports Searches
-
- … Unassigned (Assigned to ports-bugs@) (164 on 2020-07-09)
- … Assigned otherwise (67 on 2020-07-09)
- Ports & Packages with Attachment(s) (1274 on 2020-07-25) …
-
- comparable to dashboard query Ports bugs, that are ready to be taken by a committer, which is currently redundant
- not yet refined to exclude bugs such as 246873, where (2021-11-11) maintainer-approval+ is for patches that are obsolete
- does not find bugs such as 269081, where (2023-01-21) maintainer-approval+ is for something other than the patch
- … named diff (519 on 2020-07-09)
- … named patch (474 on 2020-07-09)
- … named either diff or patch (942 (43.7%) on 2020-07-25)
- … named shar (134 on 2020-07-25)
- … named diff or patch or shar (1052 (49%) on 2020-07-25)
-
- Ports & Packages without attachments (879 on 2020-07-25) …
- … and Summary contains the string "update" (56 on 2020-07-25)
- … and has the 'needs-patch' Keyword (49 on 2020-09-13)
- … and Summary contains the string "fails" (104 on 2020-07-25)
- Ports & Packages with Keyword: needs-patch (198 on 2020-09-13)
- Ports & Packages: All (2194 on 2020-07-09, 2153 on 2020-07-25, 2393 on 2020-11-15)
- Ports & Packages by Status
- New (1594 on 2021-05-07)
- Open (711 on 2021-05-07)
- In Progress (197 on 2021-05-07)
-
- The search named Ports: Maintainer Approved does not exist.
Attachment Searches
- All assume “Product” = “Ports & Packages” and “Component” == “Individual Port(s)”.
| search description | count | comments |
|---|---|---|
| Ports & Packages: All | 2154 | |
| | | |
| "attachment is patch" | 894 | |
| "Attachment is patch" and "attachment filename contains either diff or patch" | 891 | |
| "Attachment is patch" and "attachment filename contains 'diff' " | 538 | |
| "Attachment is patch" and "attachment filename contains 'patch' " | 432 | |
| "Attachment is patch" and "attachment filename contains neither diff nor patch" | 3 |
| search description | count | comments |
|---|---|---|
| Base System assigned to @FreeBSD.org but not bugs@ | 2837 | |
| Base System and "Attachment is patch" and "attachment filename contains either diff or patch" | 2422 | |
| Base System and "attachment is patch" and "attachment filename contains neither diff nor patch" | 4 | all patches have been marked obsolete |
all open, non-obsolete patch, maintainer-approval +: shared search | public search
- sorted by assignee.
Miscellaneous
all open, kde@: public search
- sorted by ID.
Advanced Search
"Custom Search"
The Bugzilla Search page has area shown under the Advanced Search link called Custom Search. With it you can do such things as the following:
- Custom Search
- “Match ALL of the following separately:”
- “Keywords” “contains the string” “ABC”
- [x] “Not” “Keywords” “contains the string” “XYZ”
Notes
We should standardize/cleanup search queries here. For example:
- queries with all products where all products are in query is not necessary, as no products = all products
- dont includes (remove) url args that are the defaults anyway:
- &keywords_type=allwords
- query_format=advanced
- others
There's very like (at least ive seen a few) completely duplicate searches here, if not significantly overlapping, as a results of the multiple search page merge done previously. Need to review and remove dupes.
Remove historic/past counts and datestamps. Challenging at best to keep up to date regularly (we dont), and out of date stats aren't that useful, and if they are, old stats dont look great. Should look into bugzilla reports more (to report these counts over time), then link to those.