tickets

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: last_pulled_from_trac (date)

owner 1 ✖

  • tekNico · 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
8312 2008-08-14 15:08:50 2011-09-28 16:12:17 2022-03-06 03:41:55.091077 Accepted closed Translations     dev fixed Wrong capitalization in Italian translation The Italian translation uses capitalized words for names of languages, months and weekdays. The standard is for all these names to be lower case. Check other systems for comparison (e.g. /usr/lib/locale on Unix). tekNico steadicat   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
    );