home / github / issues

Menu
  • Search all tables
  • GraphQL API

issues: 447408527

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
447408527 MDU6SXNzdWU0NDc0MDg1Mjc= 483 Option to facet by date using month or year 9599 open 0     5 2019-05-23T01:25:29Z 2019-05-29T21:38:27Z   OWNER  

Facet by date (from #481) can take datetimes and facet them by the day component.

https://latest.datasette.io/fixtures/facetable?_facet_date=created

I'd like to also be able to facet by month or year.

I'm not sure what the best way to achieve this is. Could be two more Facet classes (YearFacet and MonthFacet) but I think it might be nicer if the existing DateFacet could take an optional argument that changed its behaviour. But... if I do that, do I expose it in the UI somewhere or is it only available to URL-hackers?

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

Links from other tables

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