Divinorum

Above are my test prices. I am running the following search: template=staff_profile,staff_location=1119,price_list.procedure_price>=1000,price_list.procedure_price<=5000|price_list.procedure_price>=10000,price_list.procedure_price<=15000 The above search should return the first two results but not the third. Currently it finds the second but nothing else!?

It's almost like it's taking the > part of the first condition, ignoring the second argument all together!? Yet there is a service profile of 20000 and that's being (correctly) ignored. I really don;'t get what's going on

Thanks for all the suggestions so far: Im now using decimal fields for the price and adjusted the prices accordingly. I'm now using: both: template=staff_profile,staff_location=1119,@price_list.procedure_price>=1000.00,@price_list.procedure_price<=5000.00 and template=staff_profile,staff_location=1119,@price_list.procedure_price>=1000,@price_list.procedure_price<=5000 Result in a profile with a price of 1500 being selected?? I really don't get why this is being so problematic. I really do want to use Processwire for this project but this filtering issue is giving me second thoughts

$servicePage = $pages->find("template=staff_profile,services=$service,staff_location=$location_id, @price_list.price>=1000, @price_list.price<=5000, limit=$limit"); This is the code currently

When I do run @price_list.price>=1000, @price_list.price<=5000 in the query it returns 2 items: I can't understand how it's able to select these 2 pages given the query

I'm looking to search a list of services attached to peoples records. Each person has the repeater listed below called "price_list" it contains the following: Pricelist: - speciality (page reference for the actual skill they poses) - Text field listing the price its self (numeric content only) Searching the records will involve a multiple checkbox price range being passed to the search function. something like: £1000 - £5000 £5000 - £10,000 £10,000 - £15,000 £15,000 - £20,000 So depending what's passed will determine how the values are searched. I just can't seem to grasp how to search sets of values multiple times?!? I thought perhaps a find search for something like "price_list.price>=15000||price_list.price<=20000" would work but it seems to ignore it. Any thoughts?

Perfect! Many thanks @ngrmm:)

Hello all, I'm pulling a list of user profile pages I have generated based on a location filed - So far all good. My issue is I want to further filter based on a repeater field value. I have a repeater called "price_list" it contains 2x fields a page reference field called service and a text field called "price" What I want to do is search this list as I am currently but filter the results gathered based on the price field from within the repeater. For the life of me I can't figure out a way of actually doing that Is it even possible?