Matching pages by integer field fails

[Fokke]

Using the latest dev branch.

In template 'event' I have two integer fields, participantsMin and participantsMax. Both fields are optional.

In the search form I'm building a selector to match events by search terms. Let's say I want to find all the events that accept 20 participants, the selector will be the following:

template=event,participantsMin<=20|0,participantsMax>=20|0

If I edit the event page and set participantsMin to 10 and participantsMax to 40, the page will be matched. If I leave either one of the fields empty, the page will not be matched.

If I understood correctly, I need a logic something like this:

template=event,(participantsMin<=20|participantsMin=0),(participantsMax>=20|participantsMax=0)

Can't find the correct term for this... (either-or?)  

Also, got an interesting error with this selector:

template=event,participantsMin=7|0,participantsMax=7|0

Error: Exception: SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'field_participantsmin' (in /Users/Fokke/Sites/lkp/wire/core/DatabaseQuery.php line 86)

Any help will be appreciated. Thank you!

Edited January 5, 2014 by Fokke

[teppo]

On a mobile so just a quick note that either-or selectors (and this does sound like one of those) are listed in roadmap for PW 2.5+. For the time being I'd suggest finding another approach.

[Joss]

I think you are running into a problem of asking for >=  and then saying either/or. I think "greater" needs to be based on an absolute, or it does not make numeric sense.

So, if you are looking for an event that has at least 20 participants, then 

template=event,participantsMin>=20

Since the Max is always greater than the min, you dont need to even ask.

If you want a range, in other words between the min and the max then

template=event,participantsMin>=20, participantsMax<=30

The max must ALWAYS be greater than the min or it wont find a result, obviously.

EDIT

I am not sure whether PW uses the SQL Between at all. However, you could try attacking the filed twice (no idea if this works)

template=event,participantsMin>=20, participantsMin<=30