tickets

1 row where "changetime" is on date 2008-09-17 and "created" is on date 2008-09-03 sorted by summary

✎ View and edit SQL

This data as json, CSV (advanced)

created (date) 1 ✖

  • 2008-09-03 · 1 ✖

changetime (date) 1 ✖

  • 2008-09-17 · 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
8859 2008-09-03 23:25:53 2008-09-17 06:59:26 2022-03-06 03:43:21.181297 Unreviewed closed Translations     dev fixed Update the translation more consistency, more natural Mandarin Chinese. For example, changed 'password' translation from 口令 to 密码。(try Google both of them, see the number of results, 密码 is more common used.) Changed 'refresh' translation from 载入 to 刷新。 Also changed, boolean -> 布尔值; underline: 下横线 -> 下划线; checkbox: 检查框 -> 复选框; post: 张贴 -> 发表; 前导 -> 开始. Fixed typo, and update some states' name.   zhe zh-CN 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
    );