tickets

1 row where changetime = "2008-08-12 23:18:53" and "created" is on date 2008-08-12 sorted by needs_better_patch

✎ View and edit SQL

This data as json, CSV (advanced)

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

created (date) 1 ✖

  • 2008-08-12 · 1 ✖

changetime 1 ✖

  • 2008-08-12 23:18:53 · 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
8269 2008-08-12 22:53:04 2008-08-12 23:18:53 2022-03-06 03:41:48.343372 Unreviewed closed contrib.sessions     dev wontfix sessions should only be marked modified when data actually changes the modified flag on sessions currently is set on any assignment, even if you put the same data, which can make for a lot of duplicate writes nobody cgrady   0 1 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
    );