Is there a way to display the total number of published nodes in a vocabulary?? I can do it by term by clicking on header it has some @vars one can use, but I do not see a way to get a total count unless I make another view to just sort by the vocabulary only and not terms. I just hope I'm not creating to many hits to the db slowing things down.
Thanks for any info.
Follow me on: Twitter: http://twitter.com/1rubytweets Facebook: http://www.facebook.com/profile.php?id=1058306793 Join me on: Yahoo: jruby6767 Msn: jruby@charter.net
I found this eventually and am stuck. I have most of it done, but can figure out the last thing. I'll list my steps below: How to do it in Drupal 7 on Views 3: Add new view Show -> taxonomy terms Continue Relationships -> Taxonomy term: Content with term Use aggregation:Yes Taxonomy term: Name -> Group results together Add field -> Content: Nid Aggregation -> Count DISTINCT I can't figure out how to do this part below Make your own style for Content: Nid field (Set prefix to "(" and suffix to ")" to get the count between brackets)
Follow me on: Twitter: http://twitter.com/1rubytweets Facebook: http://www.facebook.com/profile.php?id=1058306793 Join me on: Yahoo: jruby6767 Msn: jruby@charter.net
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Jim Ruby Sent: Thursday, February 16, 2012 10:34 AM To: support@drupal.org Subject: [support] question about taxonomy and views
Is there a way to display the total number of published nodes in a vocabulary?? I can do it by term by clicking on header it has some @vars one can use, but I do not see a way to get a total count unless I make another view to just sort by the vocabulary only and not terms. I just hope I'm not creating to many hits to the db slowing things down.
Thanks for any info.
Follow me on: Twitter: http://twitter.com/1rubytweets Facebook: http://www.facebook.com/profile.php?id=1058306793 Join me on: Yahoo: jruby6767 Msn: jruby@charter.net
Hi, in case some one can help I have exported the view I made either I'm on track and just about there, or I mest it up. Thanks.
Export view show_counter Export $view = new view; $view->name = 'show_counter'; $view->description = ''; $view->tag = 'default'; $view->base_table = 'taxonomy_term_data'; $view->human_name = 'show counter'; $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'] = 'show counter'; $handler->display->display_options['group_by'] = TRUE; $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']['distinct'] = TRUE; $handler->display->display_options['query']['options']['query_comment'] = FALSE; $handler->display->display_options['exposed_form']['type'] = 'basic'; $handler->display->display_options['exposed_form']['options']['autosubmit'] = 0; $handler->display->display_options['exposed_form']['options']['autosubmit_hi de'] = 1; $handler->display->display_options['pager']['type'] = 'none'; $handler->display->display_options['pager']['options']['offset'] = '0'; $handler->display->display_options['style_plugin'] = 'default'; $handler->display->display_options['row_plugin'] = 'fields'; /* Relationship: Taxonomy term: Content using Archives */ $handler->display->display_options['relationships']['reverse_field_catagory_ node']['id'] = 'reverse_field_catagory_node'; $handler->display->display_options['relationships']['reverse_field_catagory_ node']['table'] = 'taxonomy_term_data'; $handler->display->display_options['relationships']['reverse_field_catagory_ node']['field'] = 'reverse_field_catagory_node'; $handler->display->display_options['relationships']['reverse_field_catagory_ node']['required'] = 0; /* Field: Taxonomy term: Name */ $handler->display->display_options['fields']['name']['id'] = 'name'; $handler->display->display_options['fields']['name']['table'] = 'taxonomy_term_data'; $handler->display->display_options['fields']['name']['field'] = 'name'; $handler->display->display_options['fields']['name']['label'] = ''; $handler->display->display_options['fields']['name']['exclude'] = TRUE; $handler->display->display_options['fields']['name']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['name']['alter']['make_link'] = 0; $handler->display->display_options['fields']['name']['alter']['absolute'] = 0; $handler->display->display_options['fields']['name']['alter']['external'] = 0; $handler->display->display_options['fields']['name']['alter']['replace_space s'] = 0; $handler->display->display_options['fields']['name']['alter']['trim_whitespa ce'] = 0; $handler->display->display_options['fields']['name']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['name']['alter']['word_boundary '] = 0; $handler->display->display_options['fields']['name']['alter']['ellipsis'] = 0; $handler->display->display_options['fields']['name']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['name']['alter']['trim'] = 0; $handler->display->display_options['fields']['name']['alter']['html'] = 0; $handler->display->display_options['fields']['name']['element_label_colon'] = FALSE; $handler->display->display_options['fields']['name']['element_default_classe s'] = 1; $handler->display->display_options['fields']['name']['hide_empty'] = 0; $handler->display->display_options['fields']['name']['empty_zero'] = 0; $handler->display->display_options['fields']['name']['hide_alter_empty'] = 1; $handler->display->display_options['fields']['name']['link_to_taxonomy'] = 1; $handler->display->display_options['fields']['name']['convert_spaces'] = 0; /* Field: Content: Nid */ $handler->display->display_options['fields']['nid']['id'] = 'nid'; $handler->display->display_options['fields']['nid']['table'] = 'node'; $handler->display->display_options['fields']['nid']['field'] = 'nid'; $handler->display->display_options['fields']['nid']['relationship'] = 'reverse_field_catagory_node'; $handler->display->display_options['fields']['nid']['alter']['alter_text'] = 0; $handler->display->display_options['fields']['nid']['alter']['make_link'] = 0; $handler->display->display_options['fields']['nid']['alter']['absolute'] = 0; $handler->display->display_options['fields']['nid']['alter']['external'] = 0; $handler->display->display_options['fields']['nid']['alter']['replace_spaces '] = 0; $handler->display->display_options['fields']['nid']['alter']['trim_whitespac e'] = 0; $handler->display->display_options['fields']['nid']['alter']['nl2br'] = 0; $handler->display->display_options['fields']['nid']['alter']['word_boundary' ] = 1; $handler->display->display_options['fields']['nid']['alter']['ellipsis'] = 1; $handler->display->display_options['fields']['nid']['alter']['strip_tags'] = 0; $handler->display->display_options['fields']['nid']['alter']['trim'] = 0; $handler->display->display_options['fields']['nid']['alter']['html'] = 0; $handler->display->display_options['fields']['nid']['element_label_colon'] = 1; $handler->display->display_options['fields']['nid']['element_default_classes '] = 1; $handler->display->display_options['fields']['nid']['hide_empty'] = 0; $handler->display->display_options['fields']['nid']['empty_zero'] = 0; $handler->display->display_options['fields']['nid']['hide_alter_empty'] = 1; $handler->display->display_options['fields']['nid']['link_to_node'] = 0; /* Filter criterion: COUNT(DISTINCT Taxonomy vocabulary: Machine name) */ $handler->display->display_options['filters']['machine_name']['id'] = 'machine_name'; $handler->display->display_options['filters']['machine_name']['table'] = 'taxonomy_vocabulary'; $handler->display->display_options['filters']['machine_name']['field'] = 'machine_name'; $handler->display->display_options['filters']['machine_name']['group_type'] = 'count_distinct'; $handler->display->display_options['filters']['machine_name']['operator'] = 'in'; /* Display: Page */ $handler = $view->new_display('page', 'Page', 'page'); $handler->display->display_options['path'] = 'show-counter'; /* Display: Block */ $handler = $view->new_display('block', 'Block', 'block'); $handler->display->display_options['defaults']['pager'] = FALSE; $handler->display->display_options['pager']['type'] = 'some'; $handler->display->display_options['pager']['options']['items_per_page'] = '5';
-
Jim Ruby