tickets

1 row where "changetime" is on date 2014-02-23 and "created" is on date 2008-08-14 sorted by summary

✎ View and edit SQL

This data as json, CSV (advanced)

created (date) 1 ✖

  • 2008-08-14 · 1 ✖

changetime (date) 1 ✖

  • 2014-02-23 · 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
8307 2008-08-14 07:05:43 2014-02-23 14:12:53 2022-03-06 03:41:54.279750 Accepted new File uploads/storage Cleanup/optimization Normal dev   ImageFile use of width_field and height_field is slow with remote storage backends im attaching a patch that could make it work jacob sebastian.serrano@gmail.com imagefile height width 0 1 0 0 1 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
    );