?_group_count=country - return counts by specific column(s) #44
Labels
Comments
|
I’m going to call this feature “count values” |
|
This should support multiple columns, e.g. |
|
Should this support sum/avg/etc as well? |
|
It would be great if this could support foreign key references and automatically resolve and hyperlink them if they are detected. |
|
This would enable faceted search - moving it to the search milestone. |
simonw
modified the milestones:
Foreign key edition,
SQLite extensions, advanced JSON and FTS search edition
simonw
added a commit
that referenced
this issue
Nov 20, 2017
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.
simonw
changed the title
|
Remaining work for this is tracked in #150 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Imagine if this:
https://stateless-datasets-jykibytogk.now.sh/flights-07d1283/airports.jsono?country__contains=gu&_group_count=country
Turned into this:
https://stateless-datasets-jykibytogk.now.sh/flights-07d1283?sql=select%20country,%20count(*)%20as%20group_count_country%20from%20airports%20where%20country%20like%20%27%gu%%27%20group%20by%20country%20order%20by%20group_count_country%20desc
This would involve introducing a new precedent of query string arguments that start with an _ having special meanings. While we're at it, could try adding _fields=x,y,z
Tasks:
The text was updated successfully, but these errors were encountered: