tickets

1 row where "created" is on date 2005-07-13 and reporter = "anonymous" sorted by component

✎ View and edit SQL

This data as json, CSV (advanced)

reporter 1 ✖

  • anonymous · 1 ✖

created (date) 1 ✖

  • 2005-07-13 · 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
2 2005-07-13 19:04:45 2007-07-03 23:04:18 2022-03-06 03:19:23.301840 Accepted closed contrib.admin defect normal   fixed Calendar popup - next/previous month links close the popup in Safari In Safari 2.0 on Tiger, the next/previous month links close the popup. There's no way to get to a different month. jacob anonymous   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
    );