file

7 rows where patch_id = 87215

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ patch_id filename
414384 87215 87215 tests/integration/README.wmv-wmcs.md
414385 87215 87215 tests/integration/config/wdio.conf.js
414386 87215 87215 tests/integration/features/step_definitions/search_steps.js
414387 87215 87215 tests/integration/features/support/hooks.js
414388 87215 87215 tests/integration/features/support/pages/article_page.js
414389 87215 87215 tests/integration/lib/tracker.js
414390 87215 87215 tests/selenium/specs/smoke_test.js

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE file (
            id INTEGER PRIMARY KEY,
            patch_id INTEGER NOT NULL,
            filename INTEGER NOT NULL,
            FOREIGN KEY(patch_id) REFERENCES patch(id)
        );
CREATE INDEX file_patch_id ON file(patch_id);