hello
thank you for correcting this : http://drupal.org/node/310063
my problem was solved but now i have a new one that i didnt have with rc3.
i have a user name filter and now, i cannot use an empty value anymore.
it is working using a user name and using the type filter, but it returns nothing if the user name field is empty ( it should return all users )

$view = new view;
$view->name = 'last_posts';
$view->description = '';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('fields', array(
  'created' => array(
    'id' => 'created',
    'table' => 'node',
    'field' => 'created',
  ),
  'title' => array(
    'label' => 'Title',
    'link_to_node' => 1,
    'exclude' => 0,
    'id' => 'title',
    'table' => 'node',
    'field' => 'title',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
  'type' => array(
    'id' => 'type',
    'table' => 'node',
    'field' => 'type',
  ),
  'name' => array(
    'label' => 'Username',
    'link_to_user' => 1,
    'exclude' => 0,
    'id' => 'name',
    'table' => 'users',
    'field' => 'name',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('sorts', array(
  'last_comment_timestamp' => array(
    'order' => 'DESC',
    'granularity' => 'second',
    'id' => 'last_comment_timestamp',
    'table' => 'node_comment_statistics',
    'field' => 'last_comment_timestamp',
    'relationship' => 'none',
  ),
  'created' => array(
    'order' => 'DESC',
    'granularity' => 'second',
    'id' => 'created',
    'table' => 'node',
    'field' => 'created',
    'relationship' => 'none',
  ),
  'changed' => array(
    'order' => 'DESC',
    'granularity' => 'second',
    'id' => 'changed',
    'table' => 'node',
    'field' => 'changed',
    'relationship' => 'none',
  ),
  'last_updated' => array(
    'order' => 'DESC',
    'granularity' => 'second',
    'id' => 'last_updated',
    'table' => 'node_comment_statistics',
    'field' => 'last_updated',
    'relationship' => 'none',
  ),
));
$handler->override_option('filters', array(
  'type' => array(
    'operator' => 'in',
    'value' => array(
      'colorseparation' => 'colorseparation',
      'digitizing' => 'digitizing',
      'heattransfer' => 'heattransfer',
      'vectorart' => 'vectorart',
    ),
    'group' => '0',
    'exposed' => TRUE,
    'expose' => array(
      'use_operator' => 0,
      'operator' => 'type_op',
      'identifier' => 'type',
      'label' => 'Node: Type',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 1,
    ),
    'id' => 'type',
    'table' => 'node',
    'field' => 'type',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Override',
    ),
  ),
  'uid' => array(
    'operator' => 'in',
    'value' => '',
    'group' => '0',
    'exposed' => TRUE,
    'expose' => array(
      'use_operator' => 0,
      'operator' => 'uid_op',
      'identifier' => 'uid',
      'label' => 'User: Name',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 0,
    ),
    'id' => 'uid',
    'table' => 'users',
    'field' => 'uid',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Override',
    ),
  ),
));
$handler->override_option('access', array(
  'type' => 'role',
  'role' => array(
    '4' => 4,
  ),
));
$handler->override_option('title', 'Last Posts');
$handler->override_option('use_more', 1);
$handler->override_option('style_plugin', 'table');
$handler->override_option('style_options', array(
  'grouping' => '',
  'override' => 1,
  'sticky' => 0,
  'order' => 'desc',
  'columns' => array(
    'created' => 'created',
    'title' => 'title',
    'type' => 'type',
    'name' => 'name',
  ),
  'info' => array(
    'created' => array(
      'sortable' => 1,
      'separator' => '',
    ),
    'title' => array(
      'sortable' => 1,
      'separator' => '',
    ),
    'type' => array(
      'sortable' => 1,
      'separator' => '',
    ),
    'name' => array(
      'sortable' => 1,
      'separator' => '',
    ),
  ),
  'default' => 'created',
));
$handler->override_option('row_plugin', 'node');
$handler->override_option('row_options', array(
  'teaser' => 1,
  'links' => 1,
));
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->override_option('path', 'last_posts');
$handler->override_option('menu', array(
  'type' => 'none',
  'title' => 'Last Posts',
  'weight' => '0',
));
$handler->override_option('tab_options', array(
  'type' => 'normal',
  'title' => '',
  'weight' => '0',
));
SELECT node.nid AS nid,
   node.created AS node_created,
   node.title AS node_title,
   node.type AS node_type,
   users.name AS users_name,
   users.uid AS users_uid
 FROM node node 
 INNER JOIN users users ON node.uid = users.uid
 WHERE (node.type in ('colorseparation', 'digitizing', 'heattransfer', 'vectorart')) AND (users.uid in (''))
   ORDER BY node_created DESC

Comments

ssm2017 Binder’s picture

the same sql query with rc3 :

SELECT node.nid AS nid,
   node.created AS node_created,
   node.title AS node_title,
   node.type AS node_type,
   users.name AS users_name,
   users.uid AS users_uid
 FROM node node 
 INNER JOIN users users ON node.uid = users.uid
 WHERE node.type in ('colorseparation', 'digitizing', 'heattransfer', 'vectorart')
   ORDER BY node_created DESC

merlinofchaos’s picture

Status: Active » Fixed

This should now be fixed in CVS. New -dev will roll at midnight GMT.

ssm2017 Binder’s picture

thank you, its working now

Anonymous’s picture

Status: Fixed » Closed (fixed)

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