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
- Quota not resetting
hi, im using appwrite's free tier plani hit my read limts last month and the billing cycle said it would reset on june 4th but that is today, the billing cycle ...
- Request for temporary 3 to 4 hours datab...
Hi Appwrite Team, I hope you are doing well.We are an early-stage startup currently running on Appwrite Cloud. We have unfortunately exhausted our database rea...
- Realtime Error Invalid query: Syntax err...
I was test driving Self-Hosted Appwrite for my use with Swift IOS apps as a backend while back and after successful trials, I started to move to incorporate int...