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
Comment #1
ssm2017 Binder commentedthe same sql query with rc3 :
Comment #2
merlinofchaos commentedThis should now be fixed in CVS. New -dev will roll at midnight GMT.
Comment #3
ssm2017 Binder commentedthank you, its working now
Comment #4
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.