Query not valid: Query type does not match expected: double

yes i know about it, but for Queries page there is no such otption

ok, just a minute

You can follow this blog - https://dev.to/appwrite/how-do-i-index-my-appwrite-collection-2o4n#:~:text=Appwrite%20supports%20three%20types%20of,match%20the%20query%20parameter%20exactly.

It’s a little old though

see

I meant a picture of this

ok

here its

from last 10 minute

give it another 20 minutes

why?

database is busy at the moment

So database distributes "power" within all users?

yes?

have small doubt like if appwrite upgraded the cloud version then my app will give error because in newer version it does not accept double value nor indexing is needed, so how can i handle this( in production mode updating takes time )

sorry i don't understand

have a slight concern. If the cloud version of Appwrite is upgraded, my app might encounter an error. This is because the newer version doesn't accept double values and indexing is no longer required. How can I manage this situation considering that updating in production mode takes time?

what do you mean newer version doesn't accept double values?

talking about this line of code Query.lessThan('totalQuantity',20.00),

previously using this line of code like this Query.lessThan('totalQuantity',20),

is totalQuantity an int?

its an double

there shouldn't be a problem with Query.lessThan('totalQuantity',20.00) at all so im not sure where the problem is

yes its working after creating index in appwrite console, but what if appwrite team migrate appwrite cloud from 1.1 to 1.3 , will this line of code work fine.

yes, it's fine to have an index. it's actually encouraged to have an index