Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
I was trying to calculate all the changes that I did in a node using an integer field.
But I didn't get it to work when I use it with Content Revision.
I tried with severals fields and nothing work. This just work when I select Content for when I create a new. Any way to make the content revisions also possible to calculate?
The code for my view here:
$view = new view;
$view->name = 'negative_quantity';
$view->description = '';
$view->tag = 'default';
$view->base_table = 'node_revision';
$view->human_name = 'Negative quantity';
$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['access']['type'] = 'perm';
$handler->display->display_options['access']['perm'] = 'view revisions';
$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['style_plugin'] = 'views_calc';
$handler->display->display_options['style_options']['columns'] = array(
'field_negative-revision_id' => 'field_negative-revision_id',
'timestamp' => 'timestamp',
);
$handler->display->display_options['style_options']['default'] = '-1';
$handler->display->display_options['style_options']['info'] = array(
'field_negative-revision_id' => array(
'sortable' => 0,
'default_sort_order' => 'asc',
'align' => '',
'separator' => '',
'empty_column' => 0,
'has_calc' => 1,
'calc' => array(
'COUNT' => 'COUNT',
'SUM' => 'SUM',
'AVG' => 'AVG',
'MIN' => 'MIN',
'MAX' => 'MAX',
),
),
'timestamp' => array(
'sortable' => 0,
'default_sort_order' => 'asc',
'align' => '',
'separator' => '',
'empty_column' => 0,
'has_calc' => 1,
'calc' => array(
'COUNT' => 'COUNT',
'SUM' => 'SUM',
'AVG' => 'AVG',
'MIN' => 'MIN',
'MAX' => 'MAX',
),
),
);
$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['style_options']['detailed_values'] = '0';
$handler->display->display_options['style_options']['precision'] = '0';
/* Field: Content (historical data): Negative */
$handler->display->display_options['fields']['field_negative-revision_id']['id'] = 'field_negative-revision_id';
$handler->display->display_options['fields']['field_negative-revision_id']['table'] = 'field_revision_field_negative';
$handler->display->display_options['fields']['field_negative-revision_id']['field'] = 'field_negative-revision_id';
$handler->display->display_options['fields']['field_negative-revision_id']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_negative-revision_id']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_negative-revision_id']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['field_negative-revision_id']['alter']['external'] = 0;
$handler->display->display_options['fields']['field_negative-revision_id']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['field_negative-revision_id']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['field_negative-revision_id']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['field_negative-revision_id']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_negative-revision_id']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_negative-revision_id']['alter']['more_link'] = 0;
$handler->display->display_options['fields']['field_negative-revision_id']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_negative-revision_id']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_negative-revision_id']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_negative-revision_id']['element_label_colon'] = 1;
$handler->display->display_options['fields']['field_negative-revision_id']['element_default_classes'] = 1;
$handler->display->display_options['fields']['field_negative-revision_id']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_negative-revision_id']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_negative-revision_id']['hide_alter_empty'] = 1;
$handler->display->display_options['fields']['field_negative-revision_id']['settings'] = array(
'thousand_separator' => ' ',
'prefix_suffix' => 1,
);
$handler->display->display_options['fields']['field_negative-revision_id']['field_api_classes'] = 0;
/* Field: Content revision: Updated date */
$handler->display->display_options['fields']['timestamp']['id'] = 'timestamp';
$handler->display->display_options['fields']['timestamp']['table'] = 'node_revision';
$handler->display->display_options['fields']['timestamp']['field'] = 'timestamp';
$handler->display->display_options['fields']['timestamp']['label'] = '';
$handler->display->display_options['fields']['timestamp']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['external'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['timestamp']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['timestamp']['alter']['more_link'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['trim'] = 0;
$handler->display->display_options['fields']['timestamp']['alter']['html'] = 0;
$handler->display->display_options['fields']['timestamp']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['timestamp']['element_default_classes'] = 1;
$handler->display->display_options['fields']['timestamp']['hide_empty'] = 0;
$handler->display->display_options['fields']['timestamp']['empty_zero'] = 0;
$handler->display->display_options['fields']['timestamp']['hide_alter_empty'] = 1;
$handler->display->display_options['fields']['timestamp']['date_format'] = 'long';
/* Contextual filter: Content: Nid */
$handler->display->display_options['arguments']['nid']['id'] = 'nid';
$handler->display->display_options['arguments']['nid']['table'] = 'node';
$handler->display->display_options['arguments']['nid']['field'] = 'nid';
$handler->display->display_options['arguments']['nid']['default_action'] = 'default';
$handler->display->display_options['arguments']['nid']['default_argument_type'] = 'node';
$handler->display->display_options['arguments']['nid']['default_argument_skip_url'] = 0;
$handler->display->display_options['arguments']['nid']['summary']['number_of_records'] = '0';
$handler->display->display_options['arguments']['nid']['summary']['format'] = 'default_summary';
$handler->display->display_options['arguments']['nid']['summary_options']['items_per_page'] = '25';
$handler->display->display_options['arguments']['nid']['break_phrase'] = 0;
$handler->display->display_options['arguments']['nid']['not'] = 0;
/* 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;