home / github / issues

Menu
  • Search all tables
  • GraphQL API

issues: 1033864602

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
1033864602 I_kwDOBm6k_c49n4Wa 1496 Named parameters docs should include an example of a cast 9599 closed 0     1 2021-10-22T18:56:04Z 2021-10-22T19:38:23Z 2021-10-22T19:34:27Z OWNER  

https://docs.datasette.io/en/stable/sql_queries.html#named-parameters

It's not obvious that the values from parameters are always SQLite strings, which means that you can't do e.g. integer comparisons on them without casting them first. The documentation here should include an example of this.

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

Links from other tables

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