I am using the Voting Api and the Fivestar module so that users can vote the content. I tried to display the content based on highest ratings by creating a relationship in views as follows:
Content: vote results
Value-type: Points
Vote-tag: The rate widget vote tag (vote)
Aggregation-function: Number of votes / Average vote / Total score

Sort criteria in Views:
(Vote results) Vote results: Value (desc/asc)

The result is not sorted. The content is displayed randomly unsorted.

This might be because of an issue with the relationship handling in the voting api. See also the following links, this might be related issues:
- http://drupal.org/node/1823924
- http://drupal.org/node/1626634

The patch proposed by http://drupal.org/node/1823924 does not work with voting api 7.x-2.10.

Does anybody has an idea how to fix this sorting issue or interface issue between the voting api and views?

I just started with Drupal and have no idea how to further troubleshoot this issue.

Comments

torotil’s picture

I've commited the patch from http://drupal.org/node/1823924 to 7.x-2.x: http://drupalcode.org/project/votingapi.git/commit/6d54f05 . The patch should also work against 2.10. Could you give it a try?

collier.matthew’s picture

Hello, I'm having the same issue here. I just installed 7.x-2.10+8-dev. Unfortunately, the issue is not resolved for me.

I am trying to sort by number of votes.

I've tried any combination of settings, but currently I have:

Configure Relationship: Content: Vote results

Value Type: No filtering
Vote Tag: meetingtopictag
Aggregate Function: Number of votes

Anything more I can do to help?

collier.matthew’s picture

I think I mistakenly assumed that the patch you mentioned was already committed to the dev version.

I rolled back to version 2.10, then...

from: sites/all/modules/votingapi

wget http://drupalcode.org/project/votingapi.git/patch/6d54f05
patch -p0 --dry-run < 6d54f05

output:
patching file b/views/votingapi.views.inc
Hunk #1 FAILED at 273.
1 out of 1 hunk FAILED -- saving rejects to file b/views/votingapi.views.inc.rej

I've never installed a patch before. Am I doing something incorrectly?

torotil’s picture

Yes there is. Could you please give me the view export and the SQL that is executed?

torotil’s picture

You're almost doing it right: you need to pass -p1 instead of -p0.

Try:
curl http://drupalcode.org/project/votingapi.git/patch/6d54f05 | patch -p1

collier.matthew’s picture

Thank you for that information. I successfully applied the patch with the correct arguments. Unfortunately, I observe no change to my sort order.

Here's my view export with the patch installed. Where do I go to get the SQL?

$view = new view();
$view->name = 'tax_term';
$view->description = '';
$view->tag = 'default';
$view->base_table = 'node';
$view->human_name = 'Tax Term';
$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['use_more_always'] = FALSE;
$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['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = '12';
$handler->display->display_options['pager']['options']['offset'] = '0';
$handler->display->display_options['pager']['options']['id'] = '0';
$handler->display->display_options['pager']['options']['quantity'] = '9';
$handler->display->display_options['style_plugin'] = 'default';
$handler->display->display_options['row_plugin'] = 'fields';
/* Relationship: Content: Vote results */
$handler->display->display_options['relationships']['votingapi_cache']['id'] = 'votingapi_cache';
$handler->display->display_options['relationships']['votingapi_cache']['table'] = 'node';
$handler->display->display_options['relationships']['votingapi_cache']['field'] = 'votingapi_cache';
$handler->display->display_options['relationships']['votingapi_cache']['votingapi'] = array(
'value_type' => '',
'tag' => 'meetingtopicvote',
'function' => 'count',
);
/* 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'] = '';
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = FALSE;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = FALSE;
/* Field: Content: Showcase Photo */
$handler->display->display_options['fields']['field_showcase_photo']['id'] = 'field_showcase_photo';
$handler->display->display_options['fields']['field_showcase_photo']['table'] = 'field_data_field_showcase_photo';
$handler->display->display_options['fields']['field_showcase_photo']['field'] = 'field_showcase_photo';
$handler->display->display_options['fields']['field_showcase_photo']['label'] = '';
$handler->display->display_options['fields']['field_showcase_photo']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_showcase_photo']['click_sort_column'] = 'fid';
$handler->display->display_options['fields']['field_showcase_photo']['settings'] = array(
'image_style' => 'medium-letterbox',
'image_link' => 'content',
);
/* Field: Content: Body */
$handler->display->display_options['fields']['body']['id'] = 'body';
$handler->display->display_options['fields']['body']['table'] = 'field_data_body';
$handler->display->display_options['fields']['body']['field'] = 'body';
$handler->display->display_options['fields']['body']['label'] = '';
$handler->display->display_options['fields']['body']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['body']['type'] = 'text_summary_or_trimmed';
$handler->display->display_options['fields']['body']['settings'] = array(
'trim_length' => '600',
);
/* Field: Content: Post date */
$handler->display->display_options['fields']['created']['id'] = 'created';
$handler->display->display_options['fields']['created']['table'] = 'node';
$handler->display->display_options['fields']['created']['field'] = 'created';
$handler->display->display_options['fields']['created']['date_format'] = 'short';
/* Field: Vote results: Value */
$handler->display->display_options['fields']['value']['id'] = 'value';
$handler->display->display_options['fields']['value']['table'] = 'votingapi_cache';
$handler->display->display_options['fields']['value']['field'] = 'value';
$handler->display->display_options['fields']['value']['relationship'] = 'votingapi_cache';
$handler->display->display_options['fields']['value']['label'] = '';
$handler->display->display_options['fields']['value']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['value']['precision'] = '0';
$handler->display->display_options['fields']['value']['appearance'] = 'rate_views_widget';
/* Sort criterion: Vote results: Function */
$handler->display->display_options['sorts']['function']['id'] = 'function';
$handler->display->display_options['sorts']['function']['table'] = 'votingapi_cache';
$handler->display->display_options['sorts']['function']['field'] = 'function';
$handler->display->display_options['sorts']['function']['relationship'] = 'votingapi_cache';
$handler->display->display_options['sorts']['function']['order'] = 'DESC';
/* Contextual filter: Content: Has taxonomy term ID (with depth) */
$handler->display->display_options['arguments']['term_node_tid_depth']['id'] = 'term_node_tid_depth';
$handler->display->display_options['arguments']['term_node_tid_depth']['table'] = 'node';
$handler->display->display_options['arguments']['term_node_tid_depth']['field'] = 'term_node_tid_depth';
$handler->display->display_options['arguments']['term_node_tid_depth']['default_argument_type'] = 'fixed';
$handler->display->display_options['arguments']['term_node_tid_depth']['summary']['number_of_records'] = '0';
$handler->display->display_options['arguments']['term_node_tid_depth']['summary']['format'] = 'default_summary';
$handler->display->display_options['arguments']['term_node_tid_depth']['summary_options']['items_per_page'] = '25';
$handler->display->display_options['arguments']['term_node_tid_depth']['depth'] = '2';
/* 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'] = 1;
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;

collier.matthew’s picture

Version: 7.x-2.10 » 7.x-2.11

Hello, I managed to solve this issue. I determined that I was attempting to sort on the incorrect field. I also updated to 7.x-2.11 today.

I changed my sort from using:
(Vote results) Vote results: Function (desc)
To:
(Vote results) Vote results: Value (desc)

torotil’s picture

Category: bug » support
Status: Active » Fixed

Nice to hear! Yes sorting by value should work better. I'm closing this as fixed. Perhaps you should also filter by function though.

Status: Fixed » Closed (fixed)

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

jmary’s picture

Status: Closed (fixed) » Active

I have the issue whatever I use. My choices are not

(Vote results) Vote results: Function (desc)
and
(Vote results) Vote results: Value (desc)

but
Score (field_score:rating)
and
Score (field_score:target)

The view is :

$view = new view();
$view->name = 'contacts_per_country';
$view->description = '';
$view->tag = 'default';
$view->base_table = 'node';
$view->human_name = 'Contacts Per Country';
$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'] = 'Contacts Per Country';
$handler->display->display_options['use_more_always'] = FALSE;
$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['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = '100';
$handler->display->display_options['pager']['options']['offset'] = '0';
$handler->display->display_options['pager']['options']['id'] = '0';
$handler->display->display_options['pager']['options']['quantity'] = '9';
$handler->display->display_options['style_plugin'] = 'table';
$handler->display->display_options['style_options']['row_class'] = '[status]';
$handler->display->display_options['style_options']['row_class_special'] = FALSE;
$handler->display->display_options['style_options']['columns'] = array(
  'counter' => 'counter',
  'status' => 'status',
  'title' => 'title',
  'field_type' => 'field_type',
  'field_address' => 'field_address',
  'field_email' => 'field_email',
  'field_phone_number' => 'field_phone_number',
  'field_url' => 'field_url',
  'field_callback_date' => 'field_callback_date',
  'title_1' => 'title_1',
  'field_score' => 'field_score',
);
$handler->display->display_options['style_options']['default'] = '-1';
$handler->display->display_options['style_options']['info'] = array(
  'counter' => array(
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'status' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'title' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => 'views-align-center',
    'separator' => '',
    'empty_column' => 0,
  ),
  'field_type' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'field_address' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'field_email' => array(
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'field_phone_number' => array(
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'field_url' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'field_callback_date' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'title_1' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
  'field_score' => array(
    'sortable' => 1,
    'default_sort_order' => 'desc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),
);
$handler->display->display_options['style_options']['sticky'] = TRUE;
/* Relationship: Entity Reference: Referencing entity */
$handler->display->display_options['relationships']['reverse_field_refer_to_node']['id'] = 'reverse_field_refer_to_node';
$handler->display->display_options['relationships']['reverse_field_refer_to_node']['table'] = 'node';
$handler->display->display_options['relationships']['reverse_field_refer_to_node']['field'] = 'reverse_field_refer_to_node';
/* Field: Global: View result counter */
$handler->display->display_options['fields']['counter']['id'] = 'counter';
$handler->display->display_options['fields']['counter']['table'] = 'views';
$handler->display->display_options['fields']['counter']['field'] = 'counter';
$handler->display->display_options['fields']['counter']['label'] = '';
$handler->display->display_options['fields']['counter']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['counter']['counter_start'] = '1';
/* Field: Content: Published */
$handler->display->display_options['fields']['status']['id'] = 'status';
$handler->display->display_options['fields']['status']['table'] = 'node';
$handler->display->display_options['fields']['status']['field'] = 'status';
$handler->display->display_options['fields']['status']['label'] = '';
$handler->display->display_options['fields']['status']['exclude'] = TRUE;
$handler->display->display_options['fields']['status']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['status']['type'] = 'enabled-disabled';
$handler->display->display_options['fields']['status']['not'] = 0;
/* 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']['alter']['word_boundary'] = FALSE;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = FALSE;
$handler->display->display_options['fields']['title']['element_label_colon'] = FALSE;
/* Field: Content: Type */
$handler->display->display_options['fields']['field_type']['id'] = 'field_type';
$handler->display->display_options['fields']['field_type']['table'] = 'field_data_field_type';
$handler->display->display_options['fields']['field_type']['field'] = 'field_type';
$handler->display->display_options['fields']['field_type']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_type']['type'] = 'taxonomy_term_reference_plain';
/* Field: Content: Address */
$handler->display->display_options['fields']['field_address']['id'] = 'field_address';
$handler->display->display_options['fields']['field_address']['table'] = 'field_data_field_address';
$handler->display->display_options['fields']['field_address']['field'] = 'field_address';
$handler->display->display_options['fields']['field_address']['click_sort_column'] = 'country';
$handler->display->display_options['fields']['field_address']['settings'] = array(
  'use_widget_handlers' => 1,
  'format_handlers' => array(
    'address' => 'address',
  ),
);
/* Field: Content: Email */
$handler->display->display_options['fields']['field_email']['id'] = 'field_email';
$handler->display->display_options['fields']['field_email']['table'] = 'field_data_field_email';
$handler->display->display_options['fields']['field_email']['field'] = 'field_email';
$handler->display->display_options['fields']['field_email']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_email']['delta_offset'] = '0';
$handler->display->display_options['fields']['field_email']['multi_type'] = 'ul';
/* Field: Content: Phone Number */
$handler->display->display_options['fields']['field_phone_number']['id'] = 'field_phone_number';
$handler->display->display_options['fields']['field_phone_number']['table'] = 'field_data_field_phone_number';
$handler->display->display_options['fields']['field_phone_number']['field'] = 'field_phone_number';
$handler->display->display_options['fields']['field_phone_number']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_phone_number']['delta_offset'] = '0';
$handler->display->display_options['fields']['field_phone_number']['multi_type'] = 'ul';
/* Field: Content: URL */
$handler->display->display_options['fields']['field_url']['id'] = 'field_url';
$handler->display->display_options['fields']['field_url']['table'] = 'field_data_field_url';
$handler->display->display_options['fields']['field_url']['field'] = 'field_url';
$handler->display->display_options['fields']['field_url']['alter']['alter_text'] = TRUE;
$handler->display->display_options['fields']['field_url']['alter']['text'] = 'Link';
$handler->display->display_options['fields']['field_url']['alter']['make_link'] = TRUE;
$handler->display->display_options['fields']['field_url']['alter']['path'] = '[field_url]';
$handler->display->display_options['fields']['field_url']['alter']['external'] = TRUE;
$handler->display->display_options['fields']['field_url']['element_label_colon'] = FALSE;
/* Field: Content: Callback Date */
$handler->display->display_options['fields']['field_callback_date']['id'] = 'field_callback_date';
$handler->display->display_options['fields']['field_callback_date']['table'] = 'field_data_field_callback_date';
$handler->display->display_options['fields']['field_callback_date']['field'] = 'field_callback_date';
$handler->display->display_options['fields']['field_callback_date']['relationship'] = 'reverse_field_refer_to_node';
$handler->display->display_options['fields']['field_callback_date']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_callback_date']['settings'] = array(
  'format_type' => 'short',
  'fromto' => 'both',
  'multiple_number' => '',
  'multiple_from' => '',
  'multiple_to' => '',
);
/* 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'] = 'reverse_field_refer_to_node';
$handler->display->display_options['fields']['title_1']['label'] = 'Note Title';
$handler->display->display_options['fields']['title_1']['element_label_colon'] = FALSE;
/* Field: Content: Score */
$handler->display->display_options['fields']['field_score']['id'] = 'field_score';
$handler->display->display_options['fields']['field_score']['table'] = 'field_data_field_score';
$handler->display->display_options['fields']['field_score']['field'] = 'field_score';
$handler->display->display_options['fields']['field_score']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_score']['click_sort_column'] = 'rating';
$handler->display->display_options['fields']['field_score']['type'] = 'fivestar_formatter_percentage';
$handler->display->display_options['fields']['field_score']['settings'] = array(
  'widget' => array(
    'fivestar_widget' => 'default',
  ),
  'expose' => 1,
  'style' => 'average',
  'text' => 'average',
);
/* 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['sorts']['title']['order'] = 'DESC';
/* Sort criterion: Content: Title */
$handler->display->display_options['sorts']['title_1']['id'] = 'title_1';
$handler->display->display_options['sorts']['title_1']['table'] = 'node';
$handler->display->display_options['sorts']['title_1']['field'] = 'title';
$handler->display->display_options['sorts']['title_1']['exposed'] = TRUE;
$handler->display->display_options['sorts']['title_1']['expose']['label'] = 'Title';
/* Sort criterion: Content: Score (field_score:rating) */
$handler->display->display_options['sorts']['field_score_rating']['id'] = 'field_score_rating';
$handler->display->display_options['sorts']['field_score_rating']['table'] = 'field_data_field_score';
$handler->display->display_options['sorts']['field_score_rating']['field'] = 'field_score_rating';
$handler->display->display_options['sorts']['field_score_rating']['order'] = 'DESC';
$handler->display->display_options['sorts']['field_score_rating']['exposed'] = TRUE;
$handler->display->display_options['sorts']['field_score_rating']['expose']['label'] = 'Score (field_score:rating)';
/* 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(
  'contact' => 'contact',
);
/* Filter criterion: Content: Address (field_address:country) */
$handler->display->display_options['filters']['field_address_country']['id'] = 'field_address_country';
$handler->display->display_options['filters']['field_address_country']['table'] = 'field_data_field_address';
$handler->display->display_options['filters']['field_address_country']['field'] = 'field_address_country';
$handler->display->display_options['filters']['field_address_country']['exposed'] = TRUE;
$handler->display->display_options['filters']['field_address_country']['expose']['operator_id'] = 'field_address_country_op';
$handler->display->display_options['filters']['field_address_country']['expose']['label'] = 'Country';
$handler->display->display_options['filters']['field_address_country']['expose']['operator'] = 'field_address_country_op';
$handler->display->display_options['filters']['field_address_country']['expose']['identifier'] = 'field_address_country';
$handler->display->display_options['filters']['field_address_country']['expose']['multiple'] = TRUE;
$handler->display->display_options['filters']['field_address_country']['expose']['remember_roles'] = array(
  2 => '2',
  1 => 0,
  3 => 0,
);
/* Filter criterion: Content: Type (field_type) */
$handler->display->display_options['filters']['field_type_tid']['id'] = 'field_type_tid';
$handler->display->display_options['filters']['field_type_tid']['table'] = 'field_data_field_type';
$handler->display->display_options['filters']['field_type_tid']['field'] = 'field_type_tid';
$handler->display->display_options['filters']['field_type_tid']['value'] = array(
  7 => '7',
  2 => '2',
  6 => '6',
  5 => '5',
  3 => '3',
  8 => '8',
  4 => '4',
  1 => '1',
);
$handler->display->display_options['filters']['field_type_tid']['exposed'] = TRUE;
$handler->display->display_options['filters']['field_type_tid']['expose']['operator_id'] = 'field_type_tid_op';
$handler->display->display_options['filters']['field_type_tid']['expose']['label'] = 'Type of Distributor';
$handler->display->display_options['filters']['field_type_tid']['expose']['use_operator'] = TRUE;
$handler->display->display_options['filters']['field_type_tid']['expose']['operator'] = 'field_type_tid_op';
$handler->display->display_options['filters']['field_type_tid']['expose']['identifier'] = 'field_type_tid';
$handler->display->display_options['filters']['field_type_tid']['expose']['remember'] = TRUE;
$handler->display->display_options['filters']['field_type_tid']['expose']['multiple'] = TRUE;
$handler->display->display_options['filters']['field_type_tid']['expose']['remember_roles'] = array(
  2 => '2',
  1 => 0,
  3 => 0,
  4 => 0,
);
$handler->display->display_options['filters']['field_type_tid']['type'] = 'select';
$handler->display->display_options['filters']['field_type_tid']['vocabulary'] = 'tags';
$handler->display->display_options['filters']['field_type_tid']['hierarchy'] = 1;
/* Filter criterion: Content: Score (field_score:rating) */
$handler->display->display_options['filters']['field_score_rating']['id'] = 'field_score_rating';
$handler->display->display_options['filters']['field_score_rating']['table'] = 'field_data_field_score';
$handler->display->display_options['filters']['field_score_rating']['field'] = 'field_score_rating';
$handler->display->display_options['filters']['field_score_rating']['operator'] = '>';
$handler->display->display_options['filters']['field_score_rating']['value']['value'] = '0';
$handler->display->display_options['filters']['field_score_rating']['exposed'] = TRUE;
$handler->display->display_options['filters']['field_score_rating']['expose']['operator_id'] = 'field_score_rating_op';
$handler->display->display_options['filters']['field_score_rating']['expose']['label'] = 'Score (field_score:rating)';
$handler->display->display_options['filters']['field_score_rating']['expose']['operator'] = 'field_score_rating_op';
$handler->display->display_options['filters']['field_score_rating']['expose']['identifier'] = 'field_score_rating';
$handler->display->display_options['filters']['field_score_rating']['expose']['remember'] = TRUE;
$handler->display->display_options['filters']['field_score_rating']['expose']['remember_roles'] = array(
  2 => '2',
  1 => 0,
  3 => 0,
  4 => 0,
);

/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page');
$handler->display->display_options['path'] = 'contacts-per-country';
$handler->display->display_options['menu']['type'] = 'normal';
$handler->display->display_options['menu']['title'] = 'Contacts Per Country';
$handler->display->display_options['menu']['name'] = 'main-menu';

and the SQL query is :

SELECT node.status AS node_status, node.title AS node_title, node.nid AS nid, field_refer_to_node.nid AS field_refer_to_node_nid, field_refer_to_node.title AS field_refer_to_node_title, field_data_field_score.field_score_rating AS field_data_field_score_field_score_rating, 'node' AS field_data_field_type_node_entity_type, 'node' AS field_data_field_address_node_entity_type, 'node' AS field_data_field_email_node_entity_type, 'node' AS field_data_field_phone_number_node_entity_type, 'node' AS field_data_field_url_node_entity_type, 'node' AS field_data_field_callback_date_node_entity_type, 'node' AS field_data_field_score_node_entity_type
FROM 
{node} node
LEFT JOIN {field_data_field_refer_to} field_data_field_refer_to ON node.nid = field_data_field_refer_to.field_refer_to_target_id
LEFT JOIN {node} field_refer_to_node ON field_data_field_refer_to.entity_id = field_refer_to_node.nid
INNER JOIN {field_data_field_type} field_data_field_type ON node.nid = field_data_field_type.entity_id AND (field_data_field_type.entity_type = 'node' AND field_data_field_type.deleted = '0')
LEFT JOIN {field_data_field_score} field_data_field_score ON node.nid = field_data_field_score.entity_id AND (field_data_field_score.entity_type = 'node' AND field_data_field_score.deleted = '0')
WHERE (( (node.type IN  ('contact')) AND (field_data_field_type.field_type_tid IN  ('7', '2', '6', '5', '3', '8', '4', '1')) AND (field_data_field_score.field_score_rating > '0') ))
ORDER BY node_title DESC
LIMIT 100 OFFSET 0
torotil’s picture

Status: Active » Closed (fixed)

@jmary please don't post to already closed fields. Judging from your view and your query votingapi is not involved in your issue.

As If’s picture

Be sure to set your data filters correctly in the relationship. You will get multiple results if you don't.