Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Datetime fields cannot be used in the where-clause #17

Open
Piiit opened this issue Apr 19, 2021 · 0 comments
Open

Datetime fields cannot be used in the where-clause #17

Piiit opened this issue Apr 19, 2021 · 0 comments
Assignees
Labels
bug Something isn't working prj:mobility

Comments

@Piiit
Copy link
Contributor

Piiit commented Apr 19, 2021

https://mobility.api.opendatahub.bz.it/v2/flat/MeteoStation/*/latest?limit=-1&where=tname.eq.precipitation,mvalidtime.gt.2016-07-13T16:20:40.861

gives

{
  "code": 400,
  "message": "SELECT EXPANSION ERROR: Syntax Error in WHERE clause: Operator 'GT.<STRING>' does not exist",
  "error": "Bad Request",
  "timestamp": 1618842668622
}
@Piiit Piiit added the bug Something isn't working label Apr 19, 2021
@Piiit Piiit self-assigned this Apr 19, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working prj:mobility
Projects
None yet
Development

No branches or pull requests

1 participant