I am not sure if this is a bug or just a misunderstanding of the features on my part.

I have a block listing Tags which have been assigned to content. I have a built a 'Relationship' between the tags and the content. I am aiming to have all tags which have content assigned to them to be listed once (and for this to act as a filter for the content, using Isotope.js).

Rather than the tags: A,B,C,D,E,F,G being displayed I am getting A,A,A,B,B,B,C,C,C,D,D,D,E,E,E,F,F,F,F,F,G,G .

I have tried using the Distinct Query setting and turning on Aggregation, in every permutation I could find but neither reduces the duplication.

Reading through the issues queue I have read Distinct doesn't work on some occasions, is that the case? Some people have mentioned using PHP to remove the Duplicates, is that the best course of action?

Is there a way of using views 'Filter Criteria' to only produce unique (distinct?) tags.
I thought I should mention that some of my content has multiple tags, e.g. both A & D.

I can recreate the content, rebuild the tags and taxonomy or whatever is needed to fix this, just not sure what route to take, what to avoid, what to implement, or if the is a 'easy fix' to what is in place!

Comments

serg2’s picture

serg2 commented

I am still stuck with this and have no more ideas to try. I have tried using aggregation too but that does not help.

Here is an export of my view:

$view = new view();
$view->name = 'isotopefilterblockbyss';
$view->description = '';
$view->tag = 'default';
$view->base_table = 'node';
$view->human_name = 'isotopefilterblockbyss';
$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'] = 'isotopefilterblockbyss';
$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'] = 'none';
$handler->display->display_options['style_plugin'] = 'isotope_filter_block';
$handler->display->display_options['row_plugin'] = 'fields';
$handler->display->display_options['row_options']['default_field_elements'] = FALSE;
/* 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: Tags */
$handler->display->display_options['fields']['field_tags']['id'] = 'field_tags';
$handler->display->display_options['fields']['field_tags']['table'] = 'field_data_field_tags';
$handler->display->display_options['fields']['field_tags']['field'] = 'field_tags';
/* Sort criterion: Content: Post date */
$handler->display->display_options['sorts']['created']['id'] = 'created';
$handler->display->display_options['sorts']['created']['table'] = 'node';
$handler->display->display_options['sorts']['created']['field'] = 'created';
$handler->display->display_options['sorts']['created']['order'] = 'DESC';
/* 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;

/* Display: Block */
$handler = $view->new_display('block', 'Block', 'block');
$handler->display->display_options['defaults']['group_by'] = FALSE;
$handler->display->display_options['defaults']['query'] = FALSE;
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['query']['options']['distinct'] = TRUE;
$handler->display->display_options['defaults']['relationships'] = FALSE;
/* Relationship: Content: Tags (field_tags) */
$handler->display->display_options['relationships']['field_tags_tid']['id'] = 'field_tags_tid';
$handler->display->display_options['relationships']['field_tags_tid']['table'] = 'field_data_field_tags';
$handler->display->display_options['relationships']['field_tags_tid']['field'] = 'field_tags_tid';
$handler->display->display_options['relationships']['field_tags_tid']['required'] = TRUE;
/* Relationship: Content: Image (field_image:fid) */
$handler->display->display_options['relationships']['field_image_fid']['id'] = 'field_image_fid';
$handler->display->display_options['relationships']['field_image_fid']['table'] = 'field_data_field_image';
$handler->display->display_options['relationships']['field_image_fid']['field'] = 'field_image_fid';
$handler->display->display_options['relationships']['field_image_fid']['required'] = TRUE;
$handler->display->display_options['defaults']['fields'] = FALSE;
/* Field: Content: Tags */
$handler->display->display_options['fields']['field_tags']['id'] = 'field_tags';
$handler->display->display_options['fields']['field_tags']['table'] = 'field_data_field_tags';
$handler->display->display_options['fields']['field_tags']['field'] = 'field_tags';
$handler->display->display_options['fields']['field_tags']['label'] = '';
$handler->display->display_options['fields']['field_tags']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_tags']['element_default_classes'] = FALSE;
$handler->display->display_options['fields']['field_tags']['type'] = 'taxonomy_term_reference_plain';
$handler->display->display_options['fields']['field_tags']['group_column'] = 'entity_id';
$handler->display->display_options['fields']['field_tags']['group_rows'] = FALSE;
$handler->display->display_options['fields']['field_tags']['delta_offset'] = '0';
$handler->display->display_options['fields']['field_tags']['multi_type'] = 'ol';
$handler->display->display_options['defaults']['sorts'] = FALSE;
/* Sort criterion: Content: Sorted Ref No. (field_sorted_ref_no_) */
$handler->display->display_options['sorts']['field_sorted_ref_no__value']['id'] = 'field_sorted_ref_no__value';
$handler->display->display_options['sorts']['field_sorted_ref_no__value']['table'] = 'field_data_field_sorted_ref_no_';
$handler->display->display_options['sorts']['field_sorted_ref_no__value']['field'] = 'field_sorted_ref_no__value';
$handler->display->display_options['defaults']['arguments'] = FALSE;
$handler->display->display_options['defaults']['filter_groups'] = FALSE;
$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'] = 1;
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;
/* Filter criterion: Content: Tags (field_tags) */
$handler->display->display_options['filters']['field_tags_tid']['id'] = 'field_tags_tid';
$handler->display->display_options['filters']['field_tags_tid']['table'] = 'field_data_field_tags';
$handler->display->display_options['filters']['field_tags_tid']['field'] = 'field_tags_tid';
$handler->display->display_options['filters']['field_tags_tid']['operator'] = 'not empty';
$handler->display->display_options['filters']['field_tags_tid']['value'] = '';
$handler->display->display_options['filters']['field_tags_tid']['vocabulary'] = 'tags';

This produces a list of 'Tags' which have been applied to content.
For each piece of content that has a tag 'example1' I get 'example1' displayed that number of time, eg if 5 pices of content are tagged 'example1' , 'example1' is displayed 5 times. I am aiming to have each tag which has an associated piece of content to be listed once so it can be used as a filter.

Any ideas?

mustanggb’s picture

mustanggb commented
Issue summary: View changes
Status: Active » Closed (outdated)