I created a filter for Node ID with operator 'Is not between', exposed, optional.
Entering min/max values (10 and 20) in the widget I get an empty result, and the query shows me why: (node.nid >= 20) AND (node.nid <= 10)
There are two op_between() functions in "views/handlers/views_handler_filter_numeric.inc" where the OR shall be used for 'Is not between'.

CommentFileSizeAuthor
#1 filter_numeric_op_not_between.patch1.82 KBmindgame
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

mindgame’s picture

How I fixed it on my installation.

merlinofchaos’s picture

Status: Active » Fixed

Ah, good catch. Though adding a NOT ( ) around it would have worked just as well I think, this is fine.

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.