Hi, I need to figure out a way to fine the number of stories posted by an author during a period. I want to use a filter where I can give a date range, for example, 1 Sept - 1 Oct to find the number of stories posted by a particular author. I have also posted a question here: http://drupal.org/node/1843268 Best Arnie
you can use views and add a count field. On Sun, Nov 18, 2012 at 12:10 PM, Swapnil <swapnil.bhartiya@gmail.com>wrote:
Hi,
I need to figure out a way to fine the number of stories posted by an author during a period. I want to use a filter where I can give a date range, for example, 1 Sept - 1 Oct to find the number of stories posted by a particular author.
I have also posted a question here: http://drupal.org/node/1843268 Best Arnie
-- [ Drupal support list | http://lists.drupal.org/ ]
On 11/18/2012 11:14 AM, Idan Arbel wrote:
you can use views and add a count field.
I could not fine the count field in views also how to see total posts by an author between given dates. Swapnil
On Sun, Nov 18, 2012 at 12:10 PM, Swapnil <swapnil.bhartiya@gmail.com <mailto:swapnil.bhartiya@gmail.com>> wrote:
Hi,
I need to figure out a way to fine the number of stories posted by an author during a period. I want to use a filter where I can give a date range, for example, 1 Sept - 1 Oct to find the number of stories posted by a particular author.
I have also posted a question here: http://drupal.org/node/1843268 Best Arnie
-- [ Drupal support list | http://lists.drupal.org/ ]
On Sun, Nov 18, 2012 at 5:55 AM, Swapnil <swapnil.bhartiya@gmail.com> wrote:
On 11/18/2012 11:14 AM, Idan Arbel wrote:
you can use views and add a count field.
I could not fine the count field in views also how to see total posts by an author between given dates.
Use the archive module. http://drupal.org/project/archive -- Earnie -- https://sites.google.com/site/earnieboyd
here's the view you're looking for: $view = new view; $view->name = 'total'; $view->description = ''; $view->tag = 'default'; $view->base_table = 'users'; $view->human_name = 'total'; $view->core = 7; $view->api_version = '3.0-alpha1'; $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'] = 'total'; $handler->display->display_options['group_by'] = TRUE; $handler->display->display_options['access']['type'] = 'perm'; $handler->display->display_options['access']['perm'] = 'access user profiles'; $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['pager']['type'] = 'full'; $handler->display->display_options['pager']['options']['items_per_page'] = '10'; $handler->display->display_options['style_plugin'] = 'default'; $handler->display->display_options['row_plugin'] = 'fields'; $handler->display->display_options['row_options']['hide_empty'] = 0; $handler->display->display_options['row_options']['default_field_elements'] = 1; /* Relationship: User: Content authored */ $handler->display->display_options['relationships']['uid']['id'] = 'uid'; $handler->display->display_options['relationships']['uid']['table'] = 'users'; $handler->display->display_options['relationships']['uid']['field'] = 'uid'; $handler->display->display_options['relationships']['uid']['required'] = 0; /* Field: User: Name */ $handler->display->display_options['fields']['name']['id'] = 'name'; $handler->display->display_options['fields']['name']['table'] = 'users'; $handler->display->display_options['fields']['name']['field'] = 'name'; $handler->display->display_options['fields']['name']['label'] = ''; $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']['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']['hide_empty'] = 0; $handler->display->display_options['fields']['name']['empty_zero'] = 0; $handler->display->display_options['fields']['name']['link_to_user'] = 1; $handler->display->display_options['fields']['name']['overwrite_anonymous'] = 0; /* Field: COUNT(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'] = 'uid'; $handler->display->display_options['fields']['nid']['group_type'] = 'count'; $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_whitespace'] = 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'] = 0; $handler->display->display_options['fields']['nid']['format_plural'] = 0; /* Sort criterion: User: Created date */ $handler->display->display_options['sorts']['created']['id'] = 'created'; $handler->display->display_options['sorts']['created']['table'] = 'users'; $handler->display->display_options['sorts']['created']['field'] = 'created'; $handler->display->display_options['sorts']['created']['order'] = 'DESC'; /* Filter criterion: User: Active */ $handler->display->display_options['filters']['status']['id'] = 'status'; $handler->display->display_options['filters']['status']['table'] = 'users'; $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; /* Display: Page */ $handler = $view->new_display('page', 'Page', 'page'); $handler->display->display_options['path'] = 'total'; On Mon, Nov 19, 2012 at 2:34 PM, Earnie Boyd <earnie@users.sourceforge.net>wrote:
On Sun, Nov 18, 2012 at 5:55 AM, Swapnil <swapnil.bhartiya@gmail.com> wrote:
On 11/18/2012 11:14 AM, Idan Arbel wrote:
you can use views and add a count field.
I could not fine the count field in views also how to see total posts by an author between given dates.
Use the archive module. http://drupal.org/project/archive
-- Earnie -- https://sites.google.com/site/earnieboyd -- [ Drupal support list | http://lists.drupal.org/ ]
Hi Adan, Thanks a lot. Just one tiny request. I want to be able to 1: expose views so I can enter name of the author and see only his stories 2: give a date range to see how many stories he posted from a-b date. I really appreciate your help. Swapnil On 11/19/2012 02:13 PM, Idan Arbel wrote:
$view = new view; $view->name = 'total'; $view->description = ''; $view->tag = 'default'; $view->base_table = 'users'; $view->human_name = 'total'; $view->core = 7; $view->api_version = '3.0-alpha1'; $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'] = 'total'; $handler->display->display_options['group_by'] = TRUE; $handler->display->display_options['access']['type'] = 'perm'; $handler->display->display_options['access']['perm'] = 'access user profiles'; $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['pager']['type'] = 'full'; $handler->display->display_options['pager']['options']['items_per_page'] = '10'; $handler->display->display_options['style_plugin'] = 'default'; $handler->display->display_options['row_plugin'] = 'fields'; $handler->display->display_options['row_options']['hide_empty'] = 0; $handler->display->display_options['row_options']['default_field_elements'] = 1; /* Relationship: User: Content authored */ $handler->display->display_options['relationships']['uid']['id'] = 'uid'; $handler->display->display_options['relationships']['uid']['table'] = 'users'; $handler->display->display_options['relationships']['uid']['field'] = 'uid'; $handler->display->display_options['relationships']['uid']['required'] = 0; /* Field: User: Name */ $handler->display->display_options['fields']['name']['id'] = 'name'; $handler->display->display_options['fields']['name']['table'] = 'users'; $handler->display->display_options['fields']['name']['field'] = 'name'; $handler->display->display_options['fields']['name']['label'] = ''; $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']['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']['hide_empty'] = 0; $handler->display->display_options['fields']['name']['empty_zero'] = 0; $handler->display->display_options['fields']['name']['link_to_user'] = 1; $handler->display->display_options['fields']['name']['overwrite_anonymous'] = 0; /* Field: COUNT(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'] = 'uid'; $handler->display->display_options['fields']['nid']['group_type'] = 'count'; $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_whitespace'] = 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'] = 0; $handler->display->display_options['fields']['nid']['format_plural'] = 0; /* Sort criterion: User: Created date */ $handler->display->display_options['sorts']['created']['id'] = 'created'; $handler->display->display_options['sorts']['created']['table'] = 'users'; $handler->display->display_options['sorts']['created']['field'] = 'created'; $handler->display->display_options['sorts']['created']['order'] = 'DESC'; /* Filter criterion: User: Active */ $handler->display->display_options['filters']['status']['id'] = 'status'; $handler->display->display_options['filters']['status']['table'] = 'users'; $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;
/* Display: Page */ $handler = $view->new_display('page', 'Page', 'page'); $handler->display->display_options['path'] = 'total';
Thanks for the view. I have managed to see the story of the author exposed in the views, I can give dates manually, but then to calculate the total stories he posted from 1-30 of a month (and that date varies) I have to do 30 manual searches for each date. Is it possible to give date range in the exposed filter to find how many stories the selected author posted between given dates. Here is the views I am using: $view = new view(); $view->name = 'total'; $view->description = ''; $view->tag = 'default'; $view->base_table = 'users'; $view->human_name = 'total'; $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'] = 'total'; $handler->display->display_options['use_more_always'] = FALSE; $handler->display->display_options['group_by'] = TRUE; $handler->display->display_options['access']['type'] = 'perm'; $handler->display->display_options['access']['perm'] = 'access user profiles'; $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['pager']['type'] = 'full'; $handler->display->display_options['pager']['options']['items_per_page'] = '10'; $handler->display->display_options['style_plugin'] = 'default'; $handler->display->display_options['row_plugin'] = 'fields'; /* Relationship: User: Content authored */ $handler->display->display_options['relationships']['uid']['id'] = 'uid'; $handler->display->display_options['relationships']['uid']['table'] = 'users'; $handler->display->display_options['relationships']['uid']['field'] = 'uid'; /* Field: User: Name */ $handler->display->display_options['fields']['name']['id'] = 'name'; $handler->display->display_options['fields']['name']['table'] = 'users'; $handler->display->display_options['fields']['name']['field'] = 'name'; $handler->display->display_options['fields']['name']['label'] = ''; $handler->display->display_options['fields']['name']['alter']['word_boundary'] = FALSE; $handler->display->display_options['fields']['name']['alter']['ellipsis'] = FALSE; /* Field: COUNT(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'] = 'uid'; $handler->display->display_options['fields']['nid']['group_type'] = 'count'; $handler->display->display_options['fields']['nid']['label'] = 'Number of Stories Posted'; $handler->display->display_options['fields']['nid']['hide_alter_empty'] = FALSE; /* Filter criterion: Content: Author uid */ $handler->display->display_options['filters']['uid']['id'] = 'uid'; $handler->display->display_options['filters']['uid']['table'] = 'node'; $handler->display->display_options['filters']['uid']['field'] = 'uid'; $handler->display->display_options['filters']['uid']['relationship'] = 'uid'; $handler->display->display_options['filters']['uid']['value'] = ''; $handler->display->display_options['filters']['uid']['exposed'] = TRUE; $handler->display->display_options['filters']['uid']['expose']['operator_id'] = 'uid_op'; $handler->display->display_options['filters']['uid']['expose']['label'] = 'Author uid'; $handler->display->display_options['filters']['uid']['expose']['operator'] = 'uid_op'; $handler->display->display_options['filters']['uid']['expose']['identifier'] = 'uid'; $handler->display->display_options['filters']['uid']['expose']['remember_roles'] = array( 2 => '2', 1 => 0, 24 => 0, 6 => 0, 5 => 0, 25 => 0, ); /* Filter criterion: Date: Date (node) */ $handler->display->display_options['filters']['date_filter_1']['id'] = 'date_filter_1'; $handler->display->display_options['filters']['date_filter_1']['table'] = 'node'; $handler->display->display_options['filters']['date_filter_1']['field'] = 'date_filter'; $handler->display->display_options['filters']['date_filter_1']['relationship'] = 'uid'; $handler->display->display_options['filters']['date_filter_1']['exposed'] = TRUE; $handler->display->display_options['filters']['date_filter_1']['expose']['operator_id'] = 'date_filter_1_op'; $handler->display->display_options['filters']['date_filter_1']['expose']['label'] = 'Date (node)'; $handler->display->display_options['filters']['date_filter_1']['expose']['operator'] = 'date_filter_1_op'; $handler->display->display_options['filters']['date_filter_1']['expose']['identifier'] = 'date_filter_1'; $handler->display->display_options['filters']['date_filter_1']['expose']['remember_roles'] = array( 2 => '2', 1 => 0, 24 => 0, 6 => 0, 5 => 0, 25 => 0, ); $handler->display->display_options['filters']['date_filter_1']['form_type'] = 'date_popup'; $handler->display->display_options['filters']['date_filter_1']['date_fields'] = array( 'node.created' => 'node.created', ); /* Display: Page */ $handler = $view->new_display('page', 'Page', 'page'); $handler->display->display_options['defaults']['hide_admin_links'] = FALSE; $handler->display->display_options['path'] = 'total'; $translatables['total'] = array( t('Master'), t('total'), t('more'), t('Apply'), t('Reset'), t('Sort by'), t('Asc'), t('Desc'), t('Items per page'), t('- All -'), t('Offset'), t('« first'), t('‹ previous'), t('next ›'), t('last »'), t('nodes'), t('Number of Stories Posted'), t('Author uid'), t('Date (node)'), t('Page'), );
participants (3)
-
Earnie Boyd -
Idan Arbel -
Swapnil