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
- Attributes Confusion
```import 'package:appwrite/models.dart'; class OrdersModel { String id, email, name, phone, status, user_id, address; int discount, total, created_at; L...
- How to Avoid Double Requests in function...
I'm currently using Appwrite's `functions.createExecution` in my project. I want to avoid double requests when multiple actions (like searching or pagination) a...
- Project in AppWrite Cloud doesn't allow ...
I have a collection where the data can't be opened. When I check the functions, there are three instances of a function still running that can't be deleted. The...