4203af5b81
Merge pull request 'Sort, filter, and limit results at /packets' (#23) from sort-filter into main
Like this from current dw logs and frontail. Fields like callsign, count, last heard, location, symbol?
Something like this (in current dw log going to frontail), but more interactive (sorting and filtering):
A lot of this work can be repurposed for #28, but I'll open a new PR for that.
Letting this branch run on the live system for a bit to see if anything breaks, then will close.
New field created_unix works. As a bonus, you can group vaguely by timestamp using a wildcard. For example, http://127.0.0.1:5001/packets?created_unix=1684029% captures values between…
You can also already pull limited time blocks using wildcards on created: http://127.0.0.1:5001/packets?created=2023-04% returns packets in April 2023.
See https://amiok.net/gitea/W1CDN/aprs_too…
To close #27, is it easier to query on timestamp or by the text version of created?
I added LIKE instead of =, which will let you do wildcards with % as in:
http://127.0.0.1:5001/packets?created=2023-04% or http://127.0.0.1:5001/packets?from=%UND%.
Excited about the latest commit, which allows you to query on any field in the frames table.
I'm not sure if you can do wildcards or not.