I know there's a similar question about price range--however this is different; user types in a SINGLE value.
I'm doing a compatibility search.
I need to search within the compatible size range.
So the range is as follows: "minimum size" and "maximum size"
("minimum size" is it's own CCK field, and so is "Maximum size")
The user would input a SINGLE value of whatever size they have and it will search within the above range.
i.e. has to be equal or greater than the min size and equal or less than the max size
Example:
Product Alpha has Compatible Range of 1.2in(min) - 1.5in(max)
Product Delta has Compatible Range of 1.6in(min) - 1.7(max)
User types in a single value: 1.4
Product Alpha should be displayed.
The problem is if I select the 2 different fields ("minimum size" and "maximum size") there is no option in "Result matching" that would allow me to say: Value must be equal or greater than "minimum size" and equal or less than "maximum size" ...... or in other words: Value must be "in between" "minimum size" and "maximum size"
Comments
Comment #1
duntuk commentedComment #2
danielb commentedYour idea of range searching is the opposite of what is supported.
Normally your node's cck field would specify a size e.g. "13.14".
And then in your finder, you create two elements, min and max, to find nodes that have a value in the right range. e.g. "10" in min and "20" in max would find the node with "13.14". Even this functionality isn't that nice to set up yet, because you can't put the ranges in a select list or anything without custom form hooks.
If functionality was added to support a range match in the way you want, it probably wouldn't be in Drupal 6.
Comment #3
danielb commentedI see you've also started a feature request for this http://drupal.org/node/1357324
Comment #4
duntuk commentedThanks Daniel for the follow-up.
Comment #5.0
(not verified) commentedremoved excessive explanation data.