I have a database that has a price field value, and I’m trying to let users filter based on price. When I filter “Under 15,000” it works for values between “10,000 and 15,000”, and when I filter “Under 20,000” it works for values between “10,000, and 20,000”. But when I filter “Under 10,000” it onl…

You are using STRINGS for comparisons = BAD IDEA!!! You must use NUMBERS!!! Your DB-FIELD must be a NUMBER-FIELD not a STRING-FIELD! This is also why you get troubles! [image] NUMBER is not = STRING ! This is what i was talking about just right from the beginning. Change your DB-FIELD -->pri…

Help Filter Not Reading Values Under 10,000

Ask the community

chriscjr11 July 23, 2022, 7:51am 12

Thank you!

Topic		Replies	Views
Price filter with "less than equal to (.le)" is not working Ask the community code , question	5	152	October 9, 2021
ge, le, between function problem Ask the community code , question	14	297	June 6, 2019
Problem with [.between-filtering] [SOLVED] Ask the community code , question	10	170	June 11, 2020
Database filters only occasionally Ask the community code , question	0	106	July 24, 2019
best way to filter by price/cost from your collection? Ask the community code , question	0	331	March 6, 2019

Help Filter Not Reading Values Under 10,000

Related topics