===== QueryStudies2 =====

The %%FreeBSD%% [[https://bugs.FreeBSD.org|Bugzilla]] Problem Report database can be daunting to those not familiar with it.

Let's try to break things down a bit.

  * The top-level concept is **Product**.  For %%FreeBSD%%, most people will be interested in **Base System** (src), **Documentation**, or **Ports & Packages**.

    * The next concept is **State**.  In %%FreeBSD%%, we primarily use **New** (raw, un-triaged), **Open** (triaged at least somewhat), and **In Progress** (at least some attempt has been made at a fix).

      * Finally, the database contains the concept **has a patch available**.  (FYI: this does not necessarily means that the patch is correct, or even applies.)

^ Product ^ State ^ Has patch? ^
| [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Base%20System&query_format=advanced&resolution=---|base system (all)]] |
| ::: | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Base%20System&bug_status=New&query_format=advanced&resolution=---|base system, New]] |  |
| ::: |  | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Base%20System&bug_status=New&f1=attachments.ispatch&o1=equals&v1=1&query_format=advanced&resolution=---|base system, New, has patch]] |
| ::: | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Base%20System&bug_status=Open&query_format=advanced&resolution=---|base system, Open]] |  |
| ::: |  | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Base%20System&bug_status=Open&f1=attachments.ispatch&o1=equals&v1=1&query_format=advanced&resolution=---|base system, Open, has patch]] |
| ::: | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Base%20System&bug_status=In%20Progress&query_format=advanced&resolution=---|base system, In Progress]] |  |
| ::: |  | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Base%20System&bug_status=In%20Progress&f1=attachments.ispatch&o1=equals&v1=1&query_format=advanced&resolution=---|base system, In Progress, has patch]] |
| [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Documentation&query_format=advanced&resolution=---|documentation (all)]] |
| ::: | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Documentation&bug_status=New&query_format=advanced&resolution=---|documentation, New]] |  |
| ::: |  | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Documentation&bug_status=New&f1=attachments.ispatch&o1=equals&v1=1&query_format=advanced&resolution=---|documentation, New, has patch]] |
| ::: | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Documentation&bug_status=Open&query_format=advanced&resolution=---|documentation, Open]] |  |
| ::: |  | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Documentation&bug_status=Open&f1=attachments.ispatch&o1=equals&v1=1&query_format=advanced&resolution=---|documentation, Open, has patch]] |
| ::: | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Documentation&bug_status=In%20Progress&query_format=advanced&resolution=---|documentation, In Progress]] |  |
| ::: |  | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Documentation&bug_status=In%20Progress&f1=attachments.ispatch&o1=equals&v1=1&query_format=advanced&resolution=---|documentation, In Progress, has patch]] |
| [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Ports%20%26%20Packages&query_format=advanced&resolution=---|ports & packages (all)]] |
| ::: | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Ports%20%26%20Packages&bug_status=New&query_format=advanced&resolution=---|ports & packages, New]] |  |
| ::: |  | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Ports%20%26%20Packages&bug_status=New&f1=attachments.ispatch&o1=equals&v1=1&query_format=advanced&resolution=---|ports & packages, New, has patch]] |
| ::: | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Ports%20%26%20Packages&bug_status=Open&query_format=advanced&resolution=---|ports & packages, Open]] |  |
| ::: |  | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Ports%20%26%20Packages&bug_status=Open&f1=attachments.ispatch&o1=equals&v1=1&query_format=advanced&resolution=---|ports & packages, Open, has patch]] |
| ::: | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Ports%20%26%20Packages&bug_status=In%20Progress&query_format=advanced&resolution=---|ports & packages, In Progress]] |  |
| ::: |  | [[https://bugs.freebsd.org/bugzilla/buglist.cgi?limit=0&order=bug_id%20DESC&product=Ports%20%26%20Packages&bug_status=In%20Progress&f1=attachments.ispatch&o1=equals&v1=1&query_format=advanced&resolution=---|ports & packages, In Progress, has patch]] |