| Both sides previous revision Previous revision Next revision | Previous revision |
| bugzilla:examplequeries [2021/05/12 12:03] – remove duplicate. MarkLinimon | bugzilla:examplequeries [2022/10/24 00:55] (current) – Merged into Bugzilla/SearchQueries KubilayKocak |
|---|
| ===== Some example queries for bugbusting ===== | |
| |
| ==== Overall ==== | |
| |
| * see some common things from the [[https://bugs.freebsd.org/bugzilla/page.cgi?id=dashboard.html|dashboard]] | |
| * PRs [[https://bugs.freebsd.org/bugzilla/buglist.cgi?keywords=regression%2C%20&keywords_type=allwords&list_id=364759&order=Bug%20Number&product=Base%20System&product=Community&product=Documentation&product=Other&product=Ports%20%26%20Packages&product=Security&product=Services&query_format=advanced&resolution=---|tagged 'regression']] ... | |
| * ... [[https://bugs.freebsd.org/bugzilla/buglist.cgi?keywords=regression%2C%20&keywords_type=allwords&list_id=364760&order=Bug%20Number&product=Base%20System&query_format=advanced&resolution=---|in the base system]] (215 as of 20200709) | |
| * ... [[https://bugs.freebsd.org/bugzilla/buglist.cgi?keywords=regression%2C%20&keywords_type=allwords&list_id=364761&order=Bug%20Number&product=Ports%20%26%20Packages&query_format=advanced&resolution=---|in ports]] (39 as of 20200709) | |
| * [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&list_id=365141&order=bug_status%20DESC%2Cbug_id%20DESC&product=Base%20System&product=Community&product=Documentation&product=Other&product=Ports%20%26%20Packages&product=Security&product=Services&query_format=advanced&resolution=---|every single PR (yikes!)]] (9857 before the [[Bugathons/202007|bugathon on 20200711]], 9750 on 20200712 afterwards, "overflow" as of 20201115) | |
| |
| ==== Ports ==== | |
| |
| * [[https://bugs.freebsd.org/bugzilla/buglist.cgi?component=Individual%20Port%28s%29&list_id=364753&product=Ports%20%26%20Packages&query_format=advanced&resolution=---&short_desc=new%20port&short_desc_type=allwordssubstr|PRs for 'new port']] | |
| * ... [[https://bugs.freebsd.org/bugzilla/buglist.cgi?component=Individual%20Port%28s%29&email1=ports-bugs%40FreeBSD.org&emailassigned_to1=1&emailtype1=equals&list_id=364754&product=Ports%20%26%20Packages&query_format=advanced&resolution=---&short_desc=new%20port&short_desc_type=allwordssubstr|assigned to ports-bugs@FreeBSD.org]] (164 as of 20200709) | |
| * ... [[https://bugs.freebsd.org/bugzilla/buglist.cgi?component=Individual%20Port%28s%29&email1=ports-bugs%40FreeBSD.org&emailassigned_to1=1&emailtype1=notequals&list_id=364756&n1=1&product=Ports%20%26%20Packages&query_format=advanced&resolution=---&short_desc=new%20port&short_desc_type=allwordssubstr|assigned otherwise]] (67 as of 20200709) | |
| * [[https://bugs.freebsd.org/bugzilla/buglist.cgi?component=Individual%20Port%28s%29&f1=attach_data.thedata&limit=0&list_id=368139&o1=isnotempty&order=bug_id%20DESC&product=Ports%20%26%20Packages&query_format=advanced&resolution=---&v1=1|ports PRs with attachments]] (1274 as of 20200725) ... | |
| * ... [[https://bugs.freebsd.org/bugzilla/buglist.cgi?component=Individual%20Port%28s%29&f1=attachments.filename&f2=attachments.filename&limit=0&list_id=364758&o1=isnotempty&o2=substring&order=bug_id%20DESC&product=Ports%20%26%20Packages&query_format=advanced&resolution=---&v2=diff|named *diff*]] (519 as of 20200709) | |
| * ... [[https://bugs.freebsd.org/bugzilla/buglist.cgi?component=Individual%20Port%28s%29&f1=attachments.filename&f2=attachments.filename&limit=0&list_id=364758&o1=isnotempty&o2=substring&order=bug_id%20DESC&product=Ports%20%26%20Packages&query_format=advanced&resolution=---&v2=patch|named *patch*]] (474 as of 20200709) | |
| * ... [[https://bugs.freebsd.org/bugzilla/buglist.cgi?component=Individual%20Port%28s%29&f1=attachments.filename&f2=attachments.filename&j_top=OR&limit=0&list_id=368089&o1=substring&o2=substring&order=bug_id%20DESC&product=Ports%20%26%20Packages&query_format=advanced&resolution=---&v1=diff&v2=patch|named either diff or patch]] (942 (43.7%) as of 20200725) | |
| * ... [[https://bugs.freebsd.org/bugzilla/buglist.cgi?component=Individual%20Port%28s%29&f1=attachments.filename&f2=attachments.filename&limit=0&list_id=364758&o1=isnotempty&o2=substring&order=bug_id%20DESC&product=Ports%20%26%20Packages&query_format=advanced&resolution=---&v2=shar|named *shar*]] (134 as of 20200725) | |
| * ... [[https://bugs.freebsd.org/bugzilla/buglist.cgi?component=Individual%20Port%28s%29&f1=attachments.filename&f2=attachments.filename&f3=attachments.filename&j_top=OR&limit=0&list_id=368124&o1=substring&o2=substring&o3=substring&order=bug_id%20DESC&product=Ports%20%26%20Packages&query_format=advanced&resolution=---&v1=diff&v2=patch&v3=shar|named either diff or patch or shar]] (1052 (49%) as of 20200725) | |
| * ports PRs [[https://bugs.freebsd.org/bugzilla/buglist.cgi?component=Individual%20Port%28s%29&f1=attach_data.thedata&limit=0&list_id=368132&o1=isempty&order=bug_id%20DESC&product=Ports%20%26%20Packages&query_format=advanced&resolution=---&v1=1|without attachments]] (879 as of 20200725) ... | |
| * ... and [[https://bugs.freebsd.org/bugzilla/buglist.cgi?component=Individual%20Port%28s%29&f1=attach_data.thedata&f2=short_desc&list_id=368133&o1=isempty&o2=substring&product=Ports%20%26%20Packages&query_format=advanced&resolution=---&v1=1&v2=update|Summary contains the string "update"]] (56 as of 20200725) | |
| * ... and [[https://bugs.freebsd.org/bugzilla/buglist.cgi?component=Individual%20Port%28s%29&f1=keywords&list_id=375784&o1=anywords&order=bug_id%20DESC&product=Ports%20%26%20Packages&query_format=advanced&resolution=---&short_desc=update&short_desc_type=allwordssubstr&v1=needs-patch|has the 'needs-patch' Keyword]] (49 as of 20200913) | |
| * ... and [[https://bugs.freebsd.org/bugzilla/buglist.cgi?component=Individual%20Port%28s%29&f1=attach_data.thedata&f2=short_desc&list_id=368133&o1=isempty&o2=substring&product=Ports%20%26%20Packages&query_format=advanced&resolution=---&v1=1&v2=fails|Summary contains the string "fails"]] (104 as of 20200725) | |
| * [[https://bugs.freebsd.org/bugzilla/buglist.cgi?component=Individual%20Port%28s%29&f1=keywords&list_id=375783&o1=anywords&order=bug_id%20DESC&product=Ports%20%26%20Packages&query_format=advanced&resolution=---&v1=needs-patch|ports PRs with the 'needs-patch' Keyword]] (198 as of 20200913) | |
| * [[https://bugs.freebsd.org/bugzilla/buglist.cgi?component=Individual%20Port%28s%29&limit=0&list_id=364816&order=bug_id%20DESC&product=Ports%20%26%20Packages&query_format=advanced&resolution=---|all ports PRs]] (scary!) (2194 as of 20200709, 2153 as of 20200725, 2393 as of 20201115) | |
| * Ports PRs by status: | |
| * [[https://bugs.freebsd.org/bugzilla/buglist.cgi?bug_status=New&limit=0&list_id=418881&order=bug_id%20DESC&product=Ports%20%26%20Packages&query_format=advanced&resolution=---|New]] (1594 as of 20210507) | |
| * [[https://bugs.freebsd.org/bugzilla/buglist.cgi?bug_status=Open&limit=0&list_id=418881&order=bug_id%20DESC&product=Ports%20%26%20Packages&query_format=advanced&resolution=---|Open]] (711 as of 20210507) | |
| * [[https://bugs.freebsd.org/bugzilla/buglist.cgi?bug_status=In%20Progress&list_id=418880&order=bug_id%20DESC&product=Ports%20%26%20Packages&query_format=advanced&resolution=---|In Progress]] (197 as of 20210507) | |
| |
| ==== Base System ==== | |
| |
| * base system PRs with attachments ... | |
| * ... [[https://bugs.freebsd.org/bugzilla/buglist.cgi?f1=attachments.filename&f2=attachments.filename&j_top=OR&limit=0&list_id=368085&o1=substring&o2=substring&order=bug_id%20DESC&product=Base%20System&query_format=advanced&resolution=---&v1=diff&v2=patch|named either diff or patch]] (1402 as of 20200725) | |
| * [[https://bugs.freebsd.org/bugzilla/buglist.cgi?f1=keywords&list_id=375787&o1=anywords&order=bug_id%20DESC&product=Base%20System&query_format=advanced&resolution=---&v1=needs-patch|base system PRs with the 'needs-patch' Keyword]] (69 as of 20200913) | |
| * [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&list_id=364817&order=bug_id%20DESC&product=Base%20System&query_format=advanced&resolution=---|all base system PRs]] (very scary!) (6830 as of 20200709, 6810 as of 20201115) | |
| * Base System PRs by status: | |
| * [[https://bugs.freebsd.org/bugzilla/buglist.cgi?bug_status=New&limit=0&list_id=418883&order=bug_id%20DESC&product=Base%20System&query_format=advanced&resolution=---|New]] (3188 as of 20210507) | |
| * [[https://bugs.freebsd.org/bugzilla/buglist.cgi?bug_status=Open&limit=0&list_id=418883&order=bug_id%20DESC&product=Base%20System&query_format=advanced&resolution=---|Open]] (3602 as of 20210507) | |
| * [[https://bugs.freebsd.org/bugzilla/buglist.cgi?bug_status=In%20Progress&limit=0&list_id=418883&order=bug_id%20DESC&product=Base%20System&query_format=advanced&resolution=---|In Progress]] (247 as of 20210507) | |
| * (see notes in [[Bugmeister/BugmeisterQA]]) | |
| |
| ==== See Also ==== | |
| |
| * [[Bugzilla/QueriesForAttachments]] | |
| |
| ---- | |
| |
| {{tag>HowTo}} | |
| |