issue_comments
3 rows where "created_at" is on date 2022-10-24 and issue_url = "https://api.github.com/repos/simonw/datasette/issues/1829"
This data as json, CSV (advanced)
Suggested facets: created_at (date)
id ▼ | html_url | issue_url | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
---|---|---|---|---|---|---|---|---|---|---|---|
1288308945 | https://github.com/simonw/datasette/issues/1829#issuecomment-1288308945 | https://api.github.com/repos/simonw/datasette/issues/1829 | IC_kwDOBm6k_c5MygjR | simonw 9599 | 2022-10-24T02:07:50Z | 2022-10-24T02:07:50Z | OWNER | Useful test: if you sign in as root to https://latest.datasette.io/_internal/columns/_internal,columns,database_name you can see there's no padlock icon on that page or on https://latest.datasette.io/_internal/columns - fixing this bug should fix that. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Table/database that is private due to inherited permissions does not show padlock 1396948693 | |
1288320411 | https://github.com/simonw/datasette/issues/1829#issuecomment-1288320411 | https://api.github.com/repos/simonw/datasette/issues/1829 | IC_kwDOBm6k_c5MyjWb | simonw 9599 | 2022-10-24T02:21:19Z | 2022-10-24T02:21:19Z | OWNER | Updated docs for `check_visibility()`: https://docs.datasette.io/en/latest/internals.html#await-check-visibility-actor-action-none-resource-none-permissions-none | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Table/database that is private due to inherited permissions does not show padlock 1396948693 | |
1288321630 | https://github.com/simonw/datasette/issues/1829#issuecomment-1288321630 | https://api.github.com/repos/simonw/datasette/issues/1829 | IC_kwDOBm6k_c5Myjpe | simonw 9599 | 2022-10-24T02:22:49Z | 2022-10-24T02:23:46Z | OWNER | Visit https://latest.datasette.io/login-as-root and then: https://latest.datasette.io/ <img width="719" alt="image" src="https://user-images.githubusercontent.com/9599/197436195-5594f1fd-4509-46c5-bd2b-dd7f5f83c004.png"> https://latest.datasette.io/_internal/columns <img width="813" alt="image" src="https://user-images.githubusercontent.com/9599/197436239-df57fa3a-216c-4de6-b77c-255824ce63b6.png"> https://latest.datasette.io/_internal/columns/_internal,columns,cid <img width="735" alt="image" src="https://user-images.githubusercontent.com/9599/197436264-e1cc5570-86b6-4a4b-8cc1-9df0f67a8275.png"> https://latest.datasette.io/_internal/from_hook <img width="443" alt="image" src="https://user-images.githubusercontent.com/9599/197436372-17380539-ce0c-48ab-bb78-a058ad14ba5a.png"> That's all as it should be. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Table/database that is private due to inherited permissions does not show padlock 1396948693 |
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]);