issue_comments
4 rows where issue = 345821500
This data as json, CSV (advanced)
Suggested facets: user, author_association, created_at (date), updated_at (date)
| id ▼ | html_url | issue_url | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 409715112 | https://github.com/simonw/datasette/issues/352#issuecomment-409715112 | https://api.github.com/repos/simonw/datasette/issues/352 | MDEyOklzc3VlQ29tbWVudDQwOTcxNTExMg== | simonw 9599 | 2018-08-01T20:41:04Z | 2018-08-01T20:41:04Z | OWNER | The hook is currently only used on the custom SQL results page - it needs to run on table/view pages as well. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | render_cell(value) plugin hook 345821500 | |
| 410485995 | https://github.com/simonw/datasette/issues/352#issuecomment-410485995 | https://api.github.com/repos/simonw/datasette/issues/352 | MDEyOklzc3VlQ29tbWVudDQxMDQ4NTk5NQ== | simonw 9599 | 2018-08-05T00:16:21Z | 2018-08-05T00:16:21Z | OWNER | First plugin using this hook: https://github.com/simonw/datasette-json-html Hook documentation: http://datasette.readthedocs.io/en/latest/plugins.html#render-cell-value | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | render_cell(value) plugin hook 345821500 | |
| 410580202 | https://github.com/simonw/datasette/issues/352#issuecomment-410580202 | https://api.github.com/repos/simonw/datasette/issues/352 | MDEyOklzc3VlQ29tbWVudDQxMDU4MDIwMg== | simonw 9599 | 2018-08-06T03:39:40Z | 2018-08-06T03:39:40Z | OWNER | I used `datasette-json-html` to build this: https://russian-ira-facebook-ads-datasette-whmbonekoj.now.sh/russian-ads-919cbfd/display_ads | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | render_cell(value) plugin hook 345821500 | |
| 584203999 | https://github.com/simonw/datasette/issues/352#issuecomment-584203999 | https://api.github.com/repos/simonw/datasette/issues/352 | MDEyOklzc3VlQ29tbWVudDU4NDIwMzk5OQ== | xrotwang 870184 | 2020-02-10T16:18:58Z | 2020-02-10T16:18:58Z | NONE | I don't want to re-open this issue, but I'm wondering whether it would be possible to include the full row for which a specific cell is to be rendered in the hook signature. My use case are rows where custom rendering would need access to multiple values (specifically, rows containing the constituents of interlinear glossed text (IGT) in separate columns, see https://github.com/cldf/cldf/tree/master/components/examples). I could probably cobble this together with custom SQL and the sql-to-html plugin. But having a full row within a `render_cell` implementation seems a lot simpler. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | render_cell(value) plugin hook 345821500 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [issue_comments] (
[html_url] TEXT,
[issue_url] TEXT,
[id] INTEGER PRIMARY KEY,
[node_id] TEXT,
[user] INTEGER REFERENCES [users]([id]),
[created_at] TEXT,
[updated_at] TEXT,
[author_association] TEXT,
[body] TEXT,
[reactions] TEXT,
[issue] INTEGER REFERENCES [issues]([id])
, [performed_via_github_app] TEXT);
CREATE INDEX [idx_issue_comments_issue]
ON [issue_comments] ([issue]);
CREATE INDEX [idx_issue_comments_user]
ON [issue_comments] ([user]);