🐛 Bug Report: Query not valid: Query type does not match expected: double on python SDK

[ZigaMatjaz]

👟 Reproduction steps

Bug is triggered when I try to use the between Query on a float attribute.

👍 Expected behavior

The query should work as the provided parameters are both float and a result should be returned.

👎 Actual Behavior

I got the error specified in the title.

🎲 Appwrite version

Version 1.3.x

💻 Operating system

Linux

🧱 Your Environment

I run appwrite on a digitalocean droplet (marketplace appwrite premade droplet)

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[stnguyen90]

@ZigaMatjaz, thanks for raising this issue!

There seems to be a problem with how were parsing and validating the query on the back end. It gets sent to the server has between("attr", [start, end]) but the validation expects input like between("attr", start, end).

Source: https://github.com/utopia-php/database/blob/d821d1f18dfe83b0350ed208be3658764aec99d7/src/Database/Query.php#L350

For now, I suggest using the greater than and less than queries instead.

[Ronakkkkk]

Please assign if available.

[EraKin575]

please assign this issue to me

[joeyouss]

Hi @Ronakkkkk you can go ahead, if you are not available to work on this, @EraKin575 can take it up after you

[KanniShashankh]

Can i work on this issue?

[stnguyen90]

@Ronakkkkk, how's your progress on this? FYI, I'll have to assign you due to inactivity soon.

[stnguyen90]

@EraKin575, would you like to work on this?

[EraKin575]

ofcourse

[stnguyen90]

@EraKin575, assigned! I appreciate your interest! 🙏🏼

[xuelink]

@ZigaMatjaz

const minDate = new Date();
minDate.setFullYear(minDate.getFullYear() - filterData?.maxAge);
const maxDate = new Date();
maxDate.setFullYear(maxDate.getFullYear() - filterData?.minAge);

Query.between("birthdate", minDate.toDateString(), maxDate.toDateString())
// Query.between("birthdate", minDate, maxDate)

AppwriteException: Invalid query: Query type does not match expected: datetime

Query.between only accept number or string

@EraKin575 When you try to focus this issue, please focus it for not only for the float type but also datetime type solutions for Query.between(). Big Thanks!

[krishnaa192]

Can I work on this issue?

[stnguyen90]

@EraKin575, how's your progress? FYI, I'll need to unassign you soon due to inactivity.