order the data being returned
Opened this issue · 1 comments
natebrennand commented
dynamically add an ORDER BY
statement to queries
In query.py we build a SQL query for each API call. Currently these requests will return the data in whatever order it was found, it would be nice if we ordered it.
This is an easy task for the /*/options/*
queries because there is only 1 column of data. However, for the queries that return all columns, we will need to choose a column to order the data on by default.
This could also be another querystring parameter to allow API consumers to determine what to order the data on.
natebrennand commented
this probably will involve restructuring the config dictionary to add a default column to order by.