I search my problem and although there are existing posts on it i can't get to a solution.
I have a problem with querying float attributes in a python function. Here is a part of the code: print(float(long - 0.06)) print(float(lat + 0.06)) listOfExistingPoint = database.list_documents('647754cad43d1180e76f', '64789c3f1418d562efc4', [ Query.between('longitude', float(long - 0.06), float(long + 0.06)), Query.between('latitude', float(lat - 0.06), float(lat + 0.06)) ] ) the above print functions write out a float value as expected (in my case 49.94 and 50.06). At this point i am casting to float every time i use the values because i have no idea why they don't get recognized as float. Any help will be appreciated 🙂
"here is the log:
49.94 50.06 Query not valid: Query type does not match expected: double
I've seen something like this before but I thought we fixed this...
yeah i found some older posts but those that had solutions didn't help
appwrite version is 1.3.5 but i still created an index in case that was a problem but sadly no
can you print the output of Query.between() and share it?
it should be between("longitude", [50.0,50.0]). which works fine for me on 1.3.4 🧐
wait..weird...it doesn't work with the python sdk..
I think there's a bug with our between query. can you create an issue for this?
In the meantime, it might be best to use greaterThan and lessThan
sorry for late response... i will try doing those. Issui on github? or where exactly i cant remember 😅
Yes, on github
okay will do
It is submitted however i had to choose that i didn't find a similar issue anywhere to be able to post, but that is not completly true, i found similar issues but the solutions did't work.
just to inform using greaterThan and lessThan works 🙂
Recommended threads
- Internal server Error when trying to exe...
When executing the function locally it works fine, but when the function is deployed I get this error: ```requests.exceptions.HTTPError: 500 Server Error: Inter...
 - Invalid query: Attribute not found in sc...
Hiya. I'm trying to use the REST API with documents and doing a simple select with query: https://<mydomain>/v1/databases/<database>/collections/<collection>/d...
 - Deploying Function fails after several d...
I get the below issue on deploying to self hosted appwrite 1.8.0 functions, restarting the docker compose, or waiting a while, fixes it but is annoying. Any ide...