Reported by @xl cheese:

Selective filter is not showing all available options, solved by tweaking the $max_items = 100; in get_oids() to a bigger number.

To do:

- The situation points to a posible wrongly constructed query when using $view_copy->set_items_per_page($max_items), because this is an aggregate query unless you have more than 100 items in the resulting. As for now, simply commenting out:

$view_copy->set_items_per_page($max_items);

will prevent the situation, but this was implemented as a safety mechanism to prevent a wrong views configuration to potentially show hundreds or thousands of options in an exposed filter.

Comments

david_garcia’s picture

david_garcia commented
Status: Active » Postponed (maintainer needs more info)

I am not able to replicate.

Anyone experimenting this same issue, please, retrieve query log in preview mode and post here.

In order to preview all queries, apply patch for views:

https://drupal.org/node/2191287

david_garcia’s picture

david_garcia commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

Query for selective values was incorrectly constructed when both Aggregate and DISTINCT or PURE DISTINCT.

Solution commited in:

http://drupalcode.org/sandbox/david_garcia_garcia/2162097.git/commit/ddb...