I have created a simple view. It is list of projects and related customers to them.

One project <-> One Customer

And now what is happening:
-> Users without "Bypass content access control" permission see only projects which have related customer.
-> Users with this permission see all projects also without related customer(customer field is empty and this is what i want)

"Require this relationship" field is of course disabled.

What I want?
I want a list like the second user sees it and I don't want to give this permission anyone except admin.

My View:

$view = new view;
$view->name = 'project_list';
$view->description = '';
$view->tag = 'List of objects';
$view->base_table = 'node';
$view->human_name = 'Project List';
$view->core = 7;
$view->api_version = '3.0';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Master */
$handler = $view->new_display('default', 'Master', 'default');
$handler->display->display_options['title'] = 'Projects';
$handler->display->display_options['access']['type'] = 'perm';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['query']['options']['query_comment'] = FALSE;
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = '50';
$handler->display->display_options['pager']['options']['offset'] = '0';
$handler->display->display_options['pager']['options']['id'] = '0';
$handler->display->display_options['pager']['options']['expose']['items_per_page_options_all'] = 0;
$handler->display->display_options['style_plugin'] = 'table';
/* Header: Global: Link */
$handler->display->display_options['header']['link']['id'] = 'link';
$handler->display->display_options['header']['link']['table'] = 'views';
$handler->display->display_options['header']['link']['field'] = 'link';
$handler->display->display_options['header']['link']['empty'] = FALSE;
/* No results behavior: Global: Text area */
$handler->display->display_options['empty']['area']['id'] = 'area';
$handler->display->display_options['empty']['area']['table'] = 'views';
$handler->display->display_options['empty']['area']['field'] = 'area';
$handler->display->display_options['empty']['area']['empty'] = FALSE;
/* Relationship: Broken/missing handler */
$handler->display->display_options['relationships']['relation_client_projects_node']['id'] = 'relation_client_projects_node';
$handler->display->display_options['relationships']['relation_client_projects_node']['table'] = 'node';
$handler->display->display_options['relationships']['relation_client_projects_node']['field'] = 'relation_client_projects_node';
/* Field: Content: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = 'Name';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['title']['alter']['external'] = 0;
$handler->display->display_options['fields']['title']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['title']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 0;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 0;
$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['element_label_colon'] = 1;
$handler->display->display_options['fields']['title']['element_default_classes'] = 1;
$handler->display->display_options['fields']['title']['hide_empty'] = 0;
$handler->display->display_options['fields']['title']['empty_zero'] = 0;
$handler->display->display_options['fields']['title']['hide_alter_empty'] = 0;
$handler->display->display_options['fields']['title']['link_to_node'] = 1;
/* Field: Content: Astreinte */
$handler->display->display_options['fields']['field_project_astreinte']['id'] = 'field_project_astreinte';
$handler->display->display_options['fields']['field_project_astreinte']['table'] = 'field_data_field_project_astreinte';
$handler->display->display_options['fields']['field_project_astreinte']['field'] = 'field_project_astreinte';
$handler->display->display_options['fields']['field_project_astreinte']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['external'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['element_label_colon'] = 1;
$handler->display->display_options['fields']['field_project_astreinte']['element_default_classes'] = 1;
$handler->display->display_options['fields']['field_project_astreinte']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['hide_alter_empty'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['type'] = 'text_default';
$handler->display->display_options['fields']['field_project_astreinte']['field_api_classes'] = 0;
/* Field: Content: Edit link */
$handler->display->display_options['fields']['edit_node']['id'] = 'edit_node';
$handler->display->display_options['fields']['edit_node']['table'] = 'node';
$handler->display->display_options['fields']['edit_node']['field'] = 'edit_node';
$handler->display->display_options['fields']['edit_node']['label'] = 'Actions';
$handler->display->display_options['fields']['edit_node']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['external'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['edit_node']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['edit_node']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['trim'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['html'] = 0;
$handler->display->display_options['fields']['edit_node']['element_label_colon'] = 1;
$handler->display->display_options['fields']['edit_node']['element_default_classes'] = 1;
$handler->display->display_options['fields']['edit_node']['hide_empty'] = 0;
$handler->display->display_options['fields']['edit_node']['empty_zero'] = 0;
$handler->display->display_options['fields']['edit_node']['hide_alter_empty'] = 0;
$handler->display->display_options['fields']['edit_node']['text'] = 'Edit';
/* Field: Content: Title */
$handler->display->display_options['fields']['title_1']['id'] = 'title_1';
$handler->display->display_options['fields']['title_1']['table'] = 'node';
$handler->display->display_options['fields']['title_1']['field'] = 'title';
/* Sort criterion: Content: Title */
$handler->display->display_options['sorts']['title']['id'] = 'title';
$handler->display->display_options['sorts']['title']['table'] = 'node';
$handler->display->display_options['sorts']['title']['field'] = 'title';
/* Filter criterion: Content: Published */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'node';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = 1;
$handler->display->display_options['filters']['status']['group'] = 0;
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;
/* Filter criterion: Content: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['value'] = array(
  'project' => 'project',
);
/* Filter criterion: Content: Title */
$handler->display->display_options['filters']['title']['id'] = 'title';
$handler->display->display_options['filters']['title']['table'] = 'node';
$handler->display->display_options['filters']['title']['field'] = 'title';
$handler->display->display_options['filters']['title']['exposed'] = TRUE;
$handler->display->display_options['filters']['title']['expose']['operator_id'] = 'title_op';
$handler->display->display_options['filters']['title']['expose']['label'] = 'Title';
$handler->display->display_options['filters']['title']['expose']['use_operator'] = FALSE;
$handler->display->display_options['filters']['title']['expose']['operator'] = 'title_op';
$handler->display->display_options['filters']['title']['expose']['identifier'] = 'title';
$handler->display->display_options['filters']['title']['expose']['remember'] = FALSE;
$handler->display->display_options['filters']['title']['expose']['multiple'] = FALSE;

/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page');
$handler->display->display_options['defaults']['title'] = FALSE;
$handler->display->display_options['title'] = 'Project List';
$handler->display->display_options['defaults']['use_ajax'] = FALSE;
$handler->display->display_options['use_ajax'] = TRUE;
$handler->display->display_options['defaults']['group_by'] = FALSE;
$handler->display->display_options['defaults']['exposed_form'] = FALSE;
$handler->display->display_options['exposed_form']['type'] = 'better_exposed_filters';
$handler->display->display_options['exposed_form']['options']['reset_button'] = TRUE;
$handler->display->display_options['exposed_form']['options']['autosubmit'] = 0;
$handler->display->display_options['exposed_form']['options']['autosubmit_hide'] = 1;
$handler->display->display_options['exposed_form']['options']['bef'] = array(
  'title_1' => array(
    'more_options' => array(
      'bef_filter_description' => '',
    ),
  ),
);
$handler->display->display_options['defaults']['style_plugin'] = FALSE;
$handler->display->display_options['style_plugin'] = 'table';
$handler->display->display_options['style_options']['columns'] = array(
  'title_1' => 'title_1',
  'title' => 'title',
  'field_project_astreinte' => 'field_project_astreinte',
  'edit_node' => 'edit_node',
  'delete_node' => 'edit_node',
);
$handler->display->display_options['style_options']['default'] = '-1';
$handler->display->display_options['style_options']['info'] = array(
  'title_1' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'title' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'field_project_astreinte' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'edit_node' => array(
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'delete_node' => array(
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
);
$handler->display->display_options['style_options']['override'] = 1;
$handler->display->display_options['style_options']['sticky'] = 0;
$handler->display->display_options['style_options']['empty_table'] = 0;
$handler->display->display_options['defaults']['style_options'] = FALSE;
$handler->display->display_options['defaults']['row_plugin'] = FALSE;
$handler->display->display_options['defaults']['row_options'] = FALSE;
$handler->display->display_options['defaults']['header'] = FALSE;
/* Header: Global: Link */
$handler->display->display_options['header']['link']['id'] = 'link';
$handler->display->display_options['header']['link']['table'] = 'views';
$handler->display->display_options['header']['link']['field'] = 'link';
$handler->display->display_options['header']['link']['label'] = 'Add project';
$handler->display->display_options['header']['link']['empty'] = TRUE;
$handler->display->display_options['header']['link']['text'] = 'Add project';
$handler->display->display_options['header']['link']['path'] = 'node/add/project';
$handler->display->display_options['header']['link']['class'] = 'mastermind-view-header-link';
$handler->display->display_options['defaults']['empty'] = FALSE;
$handler->display->display_options['defaults']['relationships'] = FALSE;
/* Relationship: Content: Relation: Customer projects (node <-> node) */
$handler->display->display_options['relationships']['relation_customer_projects_node']['id'] = 'relation_customer_projects_node';
$handler->display->display_options['relationships']['relation_customer_projects_node']['table'] = 'node';
$handler->display->display_options['relationships']['relation_customer_projects_node']['field'] = 'relation_customer_projects_node';
$handler->display->display_options['relationships']['relation_customer_projects_node']['required'] = 0;
$handler->display->display_options['defaults']['fields'] = FALSE;
/* Field: Content: Title */
$handler->display->display_options['fields']['title_1']['id'] = 'title_1';
$handler->display->display_options['fields']['title_1']['table'] = 'node';
$handler->display->display_options['fields']['title_1']['field'] = 'title';
$handler->display->display_options['fields']['title_1']['relationship'] = 'relation_customer_projects_node';
$handler->display->display_options['fields']['title_1']['group_type'] = 'min';
$handler->display->display_options['fields']['title_1']['label'] = 'Customer';
$handler->display->display_options['fields']['title_1']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title_1']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title_1']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['title_1']['alter']['external'] = 0;
$handler->display->display_options['fields']['title_1']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['title_1']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['title_1']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['title_1']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['title_1']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['title_1']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title_1']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title_1']['alter']['html'] = 0;
$handler->display->display_options['fields']['title_1']['element_label_colon'] = 1;
$handler->display->display_options['fields']['title_1']['element_default_classes'] = 1;
$handler->display->display_options['fields']['title_1']['hide_empty'] = 0;
$handler->display->display_options['fields']['title_1']['empty_zero'] = 0;
$handler->display->display_options['fields']['title_1']['hide_alter_empty'] = 0;
$handler->display->display_options['fields']['title_1']['link_to_node'] = 1;
/* Field: Content: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['group_type'] = 'min';
$handler->display->display_options['fields']['title']['label'] = 'Project';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['title']['alter']['external'] = 0;
$handler->display->display_options['fields']['title']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['title']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 0;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 0;
$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['element_label_colon'] = 1;
$handler->display->display_options['fields']['title']['element_default_classes'] = 1;
$handler->display->display_options['fields']['title']['hide_empty'] = 0;
$handler->display->display_options['fields']['title']['empty_zero'] = 0;
$handler->display->display_options['fields']['title']['hide_alter_empty'] = 0;
$handler->display->display_options['fields']['title']['link_to_node'] = 1;
/* Field: Content: Astreinte */
$handler->display->display_options['fields']['field_project_astreinte']['id'] = 'field_project_astreinte';
$handler->display->display_options['fields']['field_project_astreinte']['table'] = 'field_data_field_project_astreinte';
$handler->display->display_options['fields']['field_project_astreinte']['field'] = 'field_project_astreinte';
$handler->display->display_options['fields']['field_project_astreinte']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['external'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['element_label_colon'] = 1;
$handler->display->display_options['fields']['field_project_astreinte']['element_default_classes'] = 1;
$handler->display->display_options['fields']['field_project_astreinte']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['hide_alter_empty'] = 0;
$handler->display->display_options['fields']['field_project_astreinte']['field_api_classes'] = 0;
/* Field: Content: Edit link */
$handler->display->display_options['fields']['edit_node']['id'] = 'edit_node';
$handler->display->display_options['fields']['edit_node']['table'] = 'node';
$handler->display->display_options['fields']['edit_node']['field'] = 'edit_node';
$handler->display->display_options['fields']['edit_node']['label'] = 'Actions';
$handler->display->display_options['fields']['edit_node']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['make_link'] = 1;
$handler->display->display_options['fields']['edit_node']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['external'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['link_class'] = 'mastermind-link mastermind-edit-link';
$handler->display->display_options['fields']['edit_node']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['edit_node']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['edit_node']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['trim'] = 0;
$handler->display->display_options['fields']['edit_node']['alter']['html'] = 0;
$handler->display->display_options['fields']['edit_node']['element_label_colon'] = 1;
$handler->display->display_options['fields']['edit_node']['element_default_classes'] = 1;
$handler->display->display_options['fields']['edit_node']['hide_empty'] = 0;
$handler->display->display_options['fields']['edit_node']['empty_zero'] = 0;
$handler->display->display_options['fields']['edit_node']['hide_alter_empty'] = 0;
$handler->display->display_options['fields']['edit_node']['text'] = 'Edit';
/* Field: Content: Delete link */
$handler->display->display_options['fields']['delete_node']['id'] = 'delete_node';
$handler->display->display_options['fields']['delete_node']['table'] = 'node';
$handler->display->display_options['fields']['delete_node']['field'] = 'delete_node';
$handler->display->display_options['fields']['delete_node']['label'] = '';
$handler->display->display_options['fields']['delete_node']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['make_link'] = 1;
$handler->display->display_options['fields']['delete_node']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['link_class'] = 'mastermind-link mastermind-delete-link';
$handler->display->display_options['fields']['delete_node']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['delete_node']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['delete_node']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['trim'] = 0;
$handler->display->display_options['fields']['delete_node']['alter']['html'] = 0;
$handler->display->display_options['fields']['delete_node']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['delete_node']['element_default_classes'] = 1;
$handler->display->display_options['fields']['delete_node']['hide_empty'] = 0;
$handler->display->display_options['fields']['delete_node']['empty_zero'] = 0;
$handler->display->display_options['fields']['delete_node']['hide_alter_empty'] = 0;
$handler->display->display_options['fields']['delete_node']['text'] = 'Delete';
$handler->display->display_options['defaults']['sorts'] = FALSE;
/* Sort criterion: Content: Title */
$handler->display->display_options['sorts']['title']['id'] = 'title';
$handler->display->display_options['sorts']['title']['table'] = 'node';
$handler->display->display_options['sorts']['title']['field'] = 'title';
$handler->display->display_options['defaults']['filters'] = FALSE;
/* Filter criterion: Content: Published */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'node';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = 1;
$handler->display->display_options['filters']['status']['group'] = 0;
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;
/* Filter criterion: Content: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['value'] = array(
  'project' => 'project',
);
$handler->display->display_options['filters']['type']['group'] = 0;
/* Filter criterion: Content: Title */
$handler->display->display_options['filters']['title']['id'] = 'title';
$handler->display->display_options['filters']['title']['table'] = 'node';
$handler->display->display_options['filters']['title']['field'] = 'title';
$handler->display->display_options['filters']['title']['relationship'] = 'relation_customer_projects_node';
$handler->display->display_options['filters']['title']['operator'] = 'word';
$handler->display->display_options['filters']['title']['group'] = 0;
$handler->display->display_options['filters']['title']['exposed'] = TRUE;
$handler->display->display_options['filters']['title']['expose']['operator_id'] = 'title_op';
$handler->display->display_options['filters']['title']['expose']['label'] = 'Customer';
$handler->display->display_options['filters']['title']['expose']['operator'] = 'title_op';
$handler->display->display_options['filters']['title']['expose']['identifier'] = 'title';
$handler->display->display_options['filters']['title']['expose']['required'] = 0;
$handler->display->display_options['filters']['title']['expose']['multiple'] = FALSE;
/* Filter criterion: Content: Title */
$handler->display->display_options['filters']['title_1']['id'] = 'title_1';
$handler->display->display_options['filters']['title_1']['table'] = 'node';
$handler->display->display_options['filters']['title_1']['field'] = 'title';
$handler->display->display_options['filters']['title_1']['operator'] = 'word';
$handler->display->display_options['filters']['title_1']['group'] = 0;
$handler->display->display_options['filters']['title_1']['exposed'] = TRUE;
$handler->display->display_options['filters']['title_1']['expose']['operator_id'] = 'title_1_op';
$handler->display->display_options['filters']['title_1']['expose']['label'] = 'Project';
$handler->display->display_options['filters']['title_1']['expose']['operator'] = 'title_1_op';
$handler->display->display_options['filters']['title_1']['expose']['identifier'] = 'title_1';
$handler->display->display_options['filters']['title_1']['expose']['required'] = 0;
$handler->display->display_options['filters']['title_1']['expose']['multiple'] = FALSE;
/* Filter criterion: Content: Astreinte (field_project_astreinte) */
$handler->display->display_options['filters']['field_project_astreinte_value']['id'] = 'field_project_astreinte_value';
$handler->display->display_options['filters']['field_project_astreinte_value']['table'] = 'field_data_field_project_astreinte';
$handler->display->display_options['filters']['field_project_astreinte_value']['field'] = 'field_project_astreinte_value';
$handler->display->display_options['filters']['field_project_astreinte_value']['group'] = 0;
$handler->display->display_options['filters']['field_project_astreinte_value']['exposed'] = TRUE;
$handler->display->display_options['filters']['field_project_astreinte_value']['expose']['operator_id'] = 'field_project_astreinte_value_op';
$handler->display->display_options['filters']['field_project_astreinte_value']['expose']['label'] = 'Astreinte';
$handler->display->display_options['filters']['field_project_astreinte_value']['expose']['operator'] = 'field_project_astreinte_value_op';
$handler->display->display_options['filters']['field_project_astreinte_value']['expose']['identifier'] = 'field_project_astreinte_value';
$handler->display->display_options['filters']['field_project_astreinte_value']['expose']['reduce'] = 0;
$handler->display->display_options['path'] = 'project-list';
$handler->display->display_options['menu']['type'] = 'normal';
$handler->display->display_options['menu']['title'] = 'Project';
$handler->display->display_options['menu']['weight'] = '0';
$handler->display->display_options['menu']['name'] = 'main-menu';

Comments

MeDAN’s picture

MeDAN commented

Up

I have server list with related projects.

View preview:

Query:

SELECT node.title AS node_title, node.nid AS nid, node_field_data_endpoints.title AS node_field_data_endpoints_title
FROM 
{node} node
LEFT JOIN {field_data_endpoints} field_data_endpoints ON node.nid = field_data_endpoints.endpoints_entity_id AND field_data_endpoints.endpoints_entity_type = 'node' AND field_data_endpoints.bundle = 'server_projects'
LEFT JOIN {field_data_endpoints} field_data_endpoints_node ON field_data_endpoints_node.entity_id = field_data_endpoints.entity_id AND field_data_endpoints_node.endpoints_r_index != field_data_endpoints.endpoints_r_index AND field_data_endpoints_node.endpoints_entity_type = 'node'
LEFT JOIN {node} node_field_data_endpoints ON field_data_endpoints_node.endpoints_entity_id = node_field_data_endpoints.nid
WHERE (( (node.status = '1') AND (node.type IN  ('server')) ))
ORDER BY node_title ASC
LIMIT 15 OFFSET 0

Result:

SERVER | PROJECT
Host 1 | Project 1
Host 1 | Project 2
Host 2 | Project 3
Host 3 | 
Host 4 | Project 4
Host 4 | Project 5
Host 4 | Project 6

Server "Host 3" don't have relation with any Project so PROJECT name is NULL. Executing this query in myPHPAdmin gives me the same result BUT => Authenticated User without "Bypass content access control" permission get this:

SERVER | PROJECT
Host 1 | Project 1
Host 1 | Project 2
Host 2 | Project 3
Host 4 | Project 4
Host 4 | Project 5
Host 4 | Project 6

Of course user have all needed permissions to view server and project content type.

WHAT IS WRONG ? WHY VIEWS GIVES MY DIFFERENT RESULT THAN phpMyAdmin

dawehner’s picture

dawehner
Primary language German
commented
Priority: Major » Normal

Please don't shout here not everything can be perfect.

The problem is the node_access system, as it alters the query.

This behavior was introduced in http://drupal.org/node/1222324 as you need actually access check on relationships as well.
Maybe the last attached patch there helps you, or some other mentioned workarounds.

xjm’s picture

xjm
she/her
Primary language English
commented
Status: Active » Closed (duplicate)

Closing as duplicate of #1222324: Fix query access control on relationships (comments).

kbk’s picture

kbk commented

FWIW, I experienced this problem on a complicated view that used a Contextual Filter (argument) and setting "Specify validation criteria" and and then "Validate user has access to the content " appropriately took care of the problem.

Edit: Actually, I had an unnecessary relationship in the view and removal of that may have fixed the problem.

dharma.adusumilli’s picture

dharma.adusumilli commented

After hours of head-banging #4 worked, just removed all the unnecessary relationships and voila.
@kbk-- ppl like you are the only reason why I prefer Drupal to any other CMS.

novot86’s picture

novot86 commented

http://drupal.org/node/1276900#comment-4980066 works as workaround for me. Just Disable SQL rewriting to disable node-access check in View-> Advanced-> Query settings.

electrokate’s picture

electrokate commented

@novot86 thank you so much, this solved the problem for me in Drupal 8! :)