adicu/data.adicu.com

order the data being returned

Opened this issue · 1 comments

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.

this probably will involve restructuring the config dictionary to add a default column to order by.