Filter a range of values

Create two filters on age. For one operator, set it to >= and the other to <=. Click 'expose' on both. In the exposed filters box, set the label on the >= one to 'From', set it to Lock Operator and not optional. Set the label on 'To', lock operator, not optional.

On further reflection it may not be possible to expose the same field twice due to the IDs.

I'd always though that would be possible.

Uh. This is a bug. :/

For now, yes; and you're right, it won't be easily fixable.

Heh, I just came across this need for CCK decimal value where I want a range.

On a side note, is there any way to create an argument with an operator like <=? Meaning I'd like two args for this decimal field, one to be less than one to be greater than. This would be nice, but I suppose that this is what expose filters is for. Any hints on this bug?

Anyone found a workaround?

Ugh...I was asking if there was a way to assign operators to arguments so you could have two args with one being less than the given arg, and the other being greater than or whatever. I know it's like exposed filters so I guess there isn't any reason to want that.

Anyone found a workaround for this?

It would take a new argument or some changes to existing ones, but I am thinking this has possibilities -- arguments that can be specified as '=' (the way it works now) or '<', or '>'. Then you could stack a greater than and less than argument to filter your range.

Not sure right now how you would indicate which operator you wanted the argument to use, it would seem logical to prefix your argument with the operator (i.e. change '10' to '>10' and follow it by an argument with '<12'). but that won't work because you can't use =, <, or > in an url. Maybe some other indicator in the argument could work, or maybe it could be done with options.

I don't have any time to work on this myself right now, but I might play around with it later if no one else does it.

I'd really like to see this functionality and could throw a little donation to anyone who get's this working inside views. Let me know if anyone is working on this currently and maybe we could collaborate as well.

I'm new to views and cck (just installed both today), but maybe a possible workaround to the range selection on a cck field is to create a computed field which simply has the same value as the field you want to place the range filter on. Then you would have two fields with the same value, avoiding the need to place two filters on the same field. You could filter the original field for the "less than", and the duplicate computed field for the "greater than". I think you would need to specify in cck that the computed field be stored in the database in order for this to work. Haven't tried it yet because for some reason the only filter operators that show up for me for the CCK integer fields I'm working with are "is one of", and "is none of". If someone could explain how to get the <, >, <=, >= operators to show up, I'd gladly test my idea for the range selection and report back.

My workaround:
I have a CCK type "car" with "year of production" field.
I need to select cars produced in a range of years.
In my view ive added two filters for year: one is "equal or greater then 1950" and the other "equal or less then 2030", so all the cars fits the range.
Then ive added this function to my module:

function usacar_views_pre_query($view){ // the name of custom module is 'usacar'
  if( arg(0)!=$view->url || !arg(2)) return; //the url is "cars"
  $years=explode('-',arg(2));
  $view->filter[1]['value']=$years[0];
  $view->filter[2]['value']=$years[1];  
  //print_r($view); die;
}

Now, if I point my browser to the url "http://localhost/?q=cars/all/2001-2003" the hook in my module will just substitute the values in filters with values from url.
Mention that you should NOT add "year" to arguments in view admin form. It wont work because views module tries to process "2001-2003" as integer argument.

Thanks Budrick, that's an awesome workaround. Thanks for sharing that with us all, as I've been wondering how to accomplish this for a while. Thank you.

What module are you referring to? Views? Is that where you added the function?

My custom module named "usacar";

If you haven't found it yet, try looking at this patch. Hopefully to be included in core soon...
http://drupal.org/node/151989

See also

any solution to search one user by a range of values (integer i mean)...age...

No commits are being made to the 5.x branch at this point.