home / github / commits

Menu
  • GraphQL API

commits: 771b0ee34789750fdec176c3129eeaa6a6523041

This data as json

sha message author_date committer_date raw_author raw_committer repo author committer
771b0ee34789750fdec176c3129eeaa6a6523041 Initial implementation of ?_group_count=column URL shortcut for counting rows grouped by one or more columns. ?_group_count=column1&_group_count=column2 works as well. SQL generated looks like this: select "qSpecies", count(*) as "count" from Street_Tree_List group by "qSpecies" order by "count" desc limit 100 Or for two columns like this: select "qSpecies", "qSiteInfo", count(*) as "count" from Street_Tree_List group by "qSpecies", "qSiteInfo" order by "count" desc limit 100 Refs #44 Still todo: clean up code a bunch (it currently fakes being a 'view'), get foreign key expansion working. 2017-11-20T06:04:13Z 2017-11-20T06:04:13Z 13ae486343ea6454a93114c6f558ffea2f2c6874 13ae486343ea6454a93114c6f558ffea2f2c6874 107914493 9599 9599
Powered by Datasette · Queries took 1.334ms