tickets

1 row where "created" is on date 2008-08-14 and owner = "dgouldin" sorted by summary

✎ View and edit SQL

This data as json, CSV (advanced)

owner 1 ✖

  • dgouldin · 1 ✖

created (date) 1 ✖

  • 2008-08-14 · 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
8317 2008-08-14 17:20:11 2012-02-05 07:51:37 2022-03-06 03:41:56.038335 Accepted closed Core (Management commands) Bug Normal dev fixed inspectdb does not set primary_key=True or unique=True on foreign keys The inspectdb command will not set primary_key=True or unique=True on ForeignKey fields when the column is also a primary key. dgouldin bthomas inspectdb 0 1 0 1 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
    );