home / github / issues

Menu
  • Search all tables
  • GraphQL API

issues: 834602299

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason performed_via_github_app reactions draft state_reason
834602299 MDU6SXNzdWU4MzQ2MDIyOTk= 1262 Plugin hook that could support 'order by random()' for table view 19328961 open 0     3 2021-03-18T10:02:01Z 2021-03-18T17:55:01Z   NONE  

I am frequently using Datasette to quickly get a visual impression for a table without reviewing it in its entirety. Because I have some groups of similar records, the default sorting options mean that each page is very similar and not representative of the full dataset. The current interface allows sorting by columns, but random sorting is only available via custom SQL.

Maybe this could be a button or link.

107914493 issue    
{
    "url": "https://api.github.com/repos/simonw/datasette/issues/1262/reactions",
    "total_count": 1,
    "+1": 1,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   

Links from other tables

  • 1 row from issues_id in issues_labels
  • 3 rows from issue in issue_comments
Powered by Datasette · Queries took 1.492ms · About: github-to-sqlite