Hi @Haseeb1399 Thanks for reaching out! Do you see the same results in an app query? Curious if you've tested this query outside of Retool for comparison?
I wasn't able to reproduce an issue here, but I'd recommend removing the other parts of the where clause and then adding them back one by one to see if there is a point that causes unexpected results