Permit inequalities for issue
, time_value
#1085
Labels
api change
affect the API and its responses
suspect
efficacy and usefulness are questionable or unclear
user experience
things that affect users of our software or services
With #1070 we now support
time_value=*
andissue=*
in covidcast requests, which prevents users from having to specify ridiculous ranges like 11111111-99999999 in their queries. But if a user wants an open-ended portion of the complete calendar or history, they still have to put in silly values.Could we support inequalities like the below?
I'm not sure what a good syntax would be. Some ideas are:
<YYYYmmdd
<=YYYYmmdd
>YYYYmmdd
>=YYYYmmdd
*-YYYYmmdd
YYYYmmdd-*
We'd then have the following mapping to SQL queries:
YYYYmmdd
orYYYY-mm-dd
issue = YYYYmmdd
ortime_value = YYYYmmdd
YYYYmmdd-YYYYmmdd
orYYYY-mm-dd--YYYY-mm-dd
issue BETWEEN YYYYmmdd AND YYYYmmdd
ortime_value BETWEEN YYYYmmdd AND YYYYmmdd
*
issue
ortime_value
not included in WHERE clauseissue < YYYYmmdd
orissue <= YYYYmmdd
orissue > YYYYmmdd
orissue >= YYYYmmdd
or similar for time_valueThe text was updated successfully, but these errors were encountered: