tickets

1 row where type = "bug / defect" sorted by keywords

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: changetime (date), last_pulled_from_trac (date)

created (date) 1 ✖

id created changetime last_pulled_from_trac stage status component type severity version resolution summary description owner reporter keywords ▼ easy has_patch needs_better_patch needs_tests needs_docs ui_ux
16800 2011-09-10 01:14:14 2011-09-12 01:19:21 2022-03-06 04:04:10.260632 Unreviewed closed Uncategorized bug / defect Normal   invalid This is a test ticket 2 for detracify please close me soon narf nobody robopony   0 0 0 0 0 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE tickets (
        id int primary key,
        created datetime,
        changetime datetime,
        last_pulled_from_trac datetime,
        stage text,
        status text,
        component text,
        type text,
        severity text,
        version text,
        resolution text,
        summary text,
        description text,
        owner text,
        reporter text,
        keywords text,
        easy boolean,
        has_patch boolean,
        needs_better_patch boolean,
        needs_tests boolean,
        needs_docs boolean,
        ui_ux boolean
    );