How to create the watchdog listing per the example screenshot? [#879888]

i.e. per http://drupal.org/node/773492
Looks like you have 3 displays here with different filters (i.e. type = content, user and misc for the rest), but how do you make that summary screen showing all 3 on one page?
Thanks!
Comment	File	Size	Author
#8	how_to_create_the-879888-8.patch	13.21 KB	helmo
#7	how_to_create_the-879888-7.patch	12.83 KB	helmo
Comments

Comment #1

rstamm commented 20 August 2010 at 11:39
Unfortunately I have lost the original view, but here is a simular one. It requires PHP filter.
$view = new view;
$view->name = 'watchdog_example';
$view->description = 'Watchdog example';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'watchdog';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('relationships', array(
  'uid' => array(
    'label' => 'uid',
    'required' => 0,
    'id' => 'uid',
    'table' => 'watchdog',
    'field' => 'uid',
    'relationship' => 'none',
  ),
));
$handler->override_option('fields', array(
  'severity' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'watchdog_severity_icon' => 1,
    'watchdog_severity_icon_emerg' => 'misc/watchdog-error.png',
    'watchdog_severity_icon_alert' => 'misc/watchdog-error.png',
    'watchdog_severity_icon_critical' => 'misc/watchdog-error.png',
    'watchdog_severity_icon_error' => 'misc/watchdog-error.png',
    'watchdog_severity_icon_warning' => 'misc/watchdog-warning.png',
    'watchdog_severity_icon_notice' => '',
    'watchdog_severity_icon_info' => '',
    'watchdog_severity_icon_debug' => '',
    'exclude' => 0,
    'id' => 'severity',
    'table' => 'watchdog',
    'field' => 'severity',
    'relationship' => 'none',
  ),
  'type' => array(
    'label' => 'Type',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'exclude' => 0,
    'id' => 'type',
    'table' => 'watchdog',
    'field' => 'type',
    'relationship' => 'none',
  ),
  'timestamp' => array(
    'label' => 'Date',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'date_format' => 'small',
    'custom_date_format' => '',
    'exclude' => 0,
    'id' => 'timestamp',
    'table' => 'watchdog',
    'field' => 'timestamp',
    'relationship' => 'none',
  ),
  'message' => array(
    'label' => 'Message',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 1,
      'max_length' => '50',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'watchdog_message_link' => 1,
    'exclude' => 0,
    'id' => 'message',
    'table' => 'watchdog',
    'field' => 'message',
    'relationship' => 'none',
  ),
  'name' => array(
    'label' => 'Name',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'link_to_user' => 1,
    'overwrite_anonymous' => 0,
    'anonymous_text' => '',
    'exclude' => 0,
    'id' => 'name',
    'table' => 'users',
    'field' => 'name',
    'relationship' => 'uid',
  ),
  'link' => array(
    'label' => 'Operations',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'exclude' => 0,
    'id' => 'link',
    'table' => 'watchdog',
    'field' => 'link',
    'relationship' => 'none',
  ),
));
$handler->override_option('sorts', array(
  'wid' => array(
    'order' => 'DESC',
    'id' => 'wid',
    'table' => 'watchdog',
    'field' => 'wid',
    'relationship' => 'none',
  ),
));
$handler->override_option('filters', array(
  'type' => array(
    'operator' => 'in',
    'value' => array(),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => 'type_op',
      'label' => 'Type',
      'use_operator' => 0,
      'identifier' => 'type',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 0,
    ),
    'id' => 'type',
    'table' => 'watchdog',
    'field' => 'type',
    'relationship' => 'none',
  ),
  'severity' => array(
    'operator' => 'in',
    'value' => array(),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'severity',
    'table' => 'watchdog',
    'field' => 'severity',
    'relationship' => 'none',
  ),
));
$handler->override_option('access', array(
  'type' => 'perm',
  'perm' => 'access site reports',
));
$handler->override_option('cache', array(
  'type' => 'none',
));
$handler->override_option('title', 'Watchdog example');
$handler->override_option('footer_format', '3');
$handler->override_option('footer_empty', 0);
$handler->override_option('items_per_page', 50);
$handler->override_option('use_pager', '1');
$handler->override_option('style_plugin', 'watchdog_table');
$handler->override_option('style_options', array(
  'grouping' => '',
  'override' => 1,
  'sticky' => 1,
  'order' => 'desc',
  'columns' => array(
    'severity' => 'severity',
    'type' => 'type',
    'timestamp' => 'timestamp',
    'message' => 'message',
    'name' => 'name',
    'link' => 'link',
  ),
  'info' => array(
    'severity' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'type' => array(
      'sortable' => 1,
      'separator' => '',
    ),
    'timestamp' => array(
      'sortable' => 1,
      'separator' => '',
    ),
    'message' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'name' => array(
      'sortable' => 1,
      'separator' => '',
    ),
    'link' => array(
      'sortable' => 0,
      'separator' => '',
    ),
  ),
  'default' => 'timestamp',
  'watchdog_table_severity' => 1,
  'watchdog_table_severity_emerg' => 'dblog-emerg',
  'watchdog_table_severity_alert' => 'dblog-alert',
  'watchdog_table_severity_critical' => 'dblog-critical',
  'watchdog_table_severity_error' => 'dblog-error',
  'watchdog_table_severity_warning' => 'dblog-warning',
  'watchdog_table_severity_notice' => 'dblog-notice',
  'watchdog_table_severity_info' => 'dblog-info',
  'watchdog_table_severity_debug' => 'dblog-debug',
));
$handler = $view->new_display('page', 'Overview', 'page_1');
$handler->override_option('fields', array(
  'severity' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'watchdog_severity_icon' => 1,
    'watchdog_severity_icon_emerg' => 'misc/watchdog-error.png',
    'watchdog_severity_icon_alert' => 'misc/watchdog-error.png',
    'watchdog_severity_icon_critical' => 'misc/watchdog-error.png',
    'watchdog_severity_icon_error' => 'misc/watchdog-error.png',
    'watchdog_severity_icon_warning' => 'misc/watchdog-warning.png',
    'watchdog_severity_icon_notice' => '',
    'watchdog_severity_icon_info' => '',
    'watchdog_severity_icon_debug' => '',
    'exclude' => 0,
    'id' => 'severity',
    'table' => 'watchdog',
    'field' => 'severity',
    'relationship' => 'none',
  ),
  'type' => array(
    'label' => 'Type',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'exclude' => 0,
    'id' => 'type',
    'table' => 'watchdog',
    'field' => 'type',
    'relationship' => 'none',
  ),
  'timestamp' => array(
    'label' => 'Date',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'date_format' => 'small',
    'custom_date_format' => '',
    'exclude' => 0,
    'id' => 'timestamp',
    'table' => 'watchdog',
    'field' => 'timestamp',
    'relationship' => 'none',
  ),
  'message' => array(
    'label' => 'Message',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 1,
      'max_length' => '50',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'watchdog_message_link' => 1,
    'exclude' => 0,
    'id' => 'message',
    'table' => 'watchdog',
    'field' => 'message',
    'relationship' => 'none',
  ),
  'name' => array(
    'label' => 'Name',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'target' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
      'strip_tags' => 0,
    ),
    'empty' => '',
    'hide_empty' => 0,
    'empty_zero' => 0,
    'link_to_user' => 1,
    'overwrite_anonymous' => 0,
    'anonymous_text' => '',
    'exclude' => 0,
    'id' => 'name',
    'table' => 'users',
    'field' => 'name',
    'relationship' => 'uid',
  ),
));
$handler->override_option('filters', array(
  'wid' => array(
    'operator' => '=',
    'value' => array(
      'value' => '0',
      'min' => '',
      'max' => '',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'wid',
    'table' => 'watchdog',
    'field' => 'wid',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('empty', '<?php
$output = \'<h3>\'. t(\'Content\') .\'</h3>\';
$output .= views_embed_view(\'watchdog_example\', \'block_1\');
$output .= \'<h3>\'. t(\'User\') .\'</h3>\';
$output .= views_embed_view(\'watchdog_example\', \'block_2\');
$output .= \'<h3>\'. t(\'Page not found\') .\'</h3>\';
$output .= views_embed_view(\'watchdog_example\', \'block_3\');
$output .= \'<h3>\'. t(\'PHP\') .\'</h3>\';
$output .= views_embed_view(\'watchdog_example\', \'block_4\');
$output .= \'<h3>\'. t(\'other\') .\'</h3>\';
$output .= views_embed_view(\'watchdog_example\', \'block_5\');
return $output;
?>');
$handler->override_option('empty_format', '3');
$handler->override_option('items_per_page', 0);
$handler->override_option('use_pager', '0');
$handler->override_option('path', 'admin/reports/watchdog-example/overview');
$handler->override_option('menu', array(
  'type' => 'default tab',
  'title' => 'Overview',
  'description' => '',
  'weight' => '0',
  'name' => 'navigation',
));
$handler->override_option('tab_options', array(
  'type' => 'normal',
  'title' => 'Watchdog example',
  'description' => '',
  'weight' => '0',
  'name' => 'navigation',
));
$handler = $view->new_display('page', 'Content', 'page_2');
$handler->override_option('filters', array(
  'type' => array(
    'operator' => 'in',
    'value' => array(
      'content' => 'content',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'type',
    'table' => 'watchdog',
    'field' => 'type',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
  'severity' => array(
    'operator' => 'in',
    'value' => array(),
    'group' => '0',
    'exposed' => TRUE,
    'expose' => array(
      'use_operator' => 0,
      'operator' => 'severity_op',
      'identifier' => 'severity',
      'label' => 'Severity',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 0,
    ),
    'id' => 'severity',
    'table' => 'watchdog',
    'field' => 'severity',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
));
$handler->override_option('path', 'admin/reports/watchdog-example/content');
$handler->override_option('menu', array(
  'type' => 'tab',
  'title' => 'Content',
  'description' => '',
  'weight' => '10',
  'name' => 'navigation',
));
$handler->override_option('tab_options', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
  'name' => 'navigation',
));
$handler = $view->new_display('page', 'User', 'page_3');
$handler->override_option('filters', array(
  'type' => array(
    'operator' => 'in',
    'value' => array(
      'user' => 'user',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'type',
    'table' => 'watchdog',
    'field' => 'type',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
  'severity' => array(
    'operator' => 'in',
    'value' => array(),
    'group' => '0',
    'exposed' => TRUE,
    'expose' => array(
      'use_operator' => 0,
      'operator' => 'severity_op',
      'identifier' => 'severity',
      'label' => 'Severity',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 0,
    ),
    'id' => 'severity',
    'table' => 'watchdog',
    'field' => 'severity',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
));
$handler->override_option('path', 'admin/reports/watchdog-example/user');
$handler->override_option('menu', array(
  'type' => 'tab',
  'title' => 'User',
  'description' => '',
  'weight' => '20',
  'name' => 'navigation',
));
$handler->override_option('tab_options', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
  'name' => 'navigation',
));
$handler = $view->new_display('page', 'Page not found', 'page_4');
$handler->override_option('filters', array(
  'type' => array(
    'operator' => 'in',
    'value' => array(
      'page not found' => 'page not found',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'type',
    'table' => 'watchdog',
    'field' => 'type',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
  'severity' => array(
    'operator' => 'in',
    'value' => array(),
    'group' => '0',
    'exposed' => TRUE,
    'expose' => array(
      'use_operator' => 0,
      'operator' => 'severity_op',
      'identifier' => 'severity',
      'label' => 'Severity',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 0,
    ),
    'id' => 'severity',
    'table' => 'watchdog',
    'field' => 'severity',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
));
$handler->override_option('path', 'admin/reports/watchdog-example/page-not-found');
$handler->override_option('menu', array(
  'type' => 'tab',
  'title' => 'Page not found',
  'description' => '',
  'weight' => '30',
  'name' => 'navigation',
));
$handler->override_option('tab_options', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
  'name' => 'navigation',
));
$handler = $view->new_display('page', 'PHP', 'page_5');
$handler->override_option('filters', array(
  'type' => array(
    'operator' => 'in',
    'value' => array(
      'php' => 'php',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'type',
    'table' => 'watchdog',
    'field' => 'type',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
  'severity' => array(
    'operator' => 'in',
    'value' => array(),
    'group' => '0',
    'exposed' => TRUE,
    'expose' => array(
      'use_operator' => 0,
      'operator' => 'severity_op',
      'identifier' => 'severity',
      'label' => 'Severity',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 0,
    ),
    'id' => 'severity',
    'table' => 'watchdog',
    'field' => 'severity',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
));
$handler->override_option('path', 'admin/reports/watchdog-example/php');
$handler->override_option('menu', array(
  'type' => 'tab',
  'title' => 'PHP',
  'description' => '',
  'weight' => '40',
  'name' => 'navigation',
));
$handler->override_option('tab_options', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
  'name' => 'navigation',
));
$handler = $view->new_display('page', 'other', 'page_6');
$handler->override_option('filters', array(
  'type' => array(
    'operator' => 'not in',
    'value' => array(
      'content' => 'content',
      'page not found' => 'page not found',
      'php' => 'php',
      'user' => 'user',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => 'type_op',
      'label' => 'Type',
      'use_operator' => 0,
      'identifier' => 'type',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 1,
    ),
    'id' => 'type',
    'table' => 'watchdog',
    'field' => 'type',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
  'type_1' => array(
    'operator' => 'in',
    'value' => array(),
    'group' => '0',
    'exposed' => TRUE,
    'expose' => array(
      'use_operator' => 0,
      'operator' => 'type_1_op',
      'identifier' => 'type_1',
      'label' => 'Type',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 0,
    ),
    'id' => 'type_1',
    'table' => 'watchdog',
    'field' => 'type',
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
  ),
  'severity' => array(
    'operator' => 'in',
    'value' => array(),
    'group' => '0',
    'exposed' => TRUE,
    'expose' => array(
      'use_operator' => 0,
      'operator' => 'severity_op',
      'identifier' => 'severity',
      'label' => 'Severity',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 0,
    ),
    'id' => 'severity',
    'table' => 'watchdog',
    'field' => 'severity',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
));
$handler->override_option('path', 'admin/reports/watchdog-example/other');
$handler->override_option('menu', array(
  'type' => 'tab',
  'title' => 'other',
  'description' => '',
  'weight' => '50',
  'name' => 'navigation',
));
$handler->override_option('tab_options', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
  'name' => 'navigation',
));
$handler = $view->new_display('block', 'Overview Content', 'block_1');
$handler->override_option('filters', array(
  'type' => array(
    'operator' => 'in',
    'value' => array(
      'content' => 'content',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => 'type_op',
      'label' => 'Type',
      'use_operator' => 0,
      'identifier' => 'type',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 0,
    ),
    'id' => 'type',
    'table' => 'watchdog',
    'field' => 'type',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
));
$handler->override_option('items_per_page', 10);
$handler->override_option('use_pager', '0');
$handler->override_option('use_more', 1);
$handler->override_option('use_more_always', 1);
$handler->override_option('link_display', 'page_2');
$handler->override_option('style_options', array(
  'grouping' => '',
  'override' => 0,
  'sticky' => 0,
  'order' => 'desc',
  'columns' => array(
    'severity' => 'severity',
    'type' => 'type',
    'timestamp' => 'timestamp',
    'message' => 'message',
    'name' => 'name',
    'link' => 'link',
  ),
  'info' => array(
    'severity' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'type' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'timestamp' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'message' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'name' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'link' => array(
      'sortable' => 0,
      'separator' => '',
    ),
  ),
  'default' => '-1',
  'watchdog_table_severity' => 1,
  'watchdog_table_severity_emerg' => 'dblog-emerg',
  'watchdog_table_severity_alert' => 'dblog-alert',
  'watchdog_table_severity_critical' => 'dblog-critical',
  'watchdog_table_severity_error' => 'dblog-error',
  'watchdog_table_severity_warning' => 'dblog-warning',
  'watchdog_table_severity_notice' => 'dblog-notice',
  'watchdog_table_severity_info' => 'dblog-info',
  'watchdog_table_severity_debug' => 'dblog-debug',
));
$handler->override_option('block_description', '');
$handler->override_option('block_caching', -1);
$handler = $view->new_display('block', 'Overview User', 'block_2');
$handler->override_option('filters', array(
  'type' => array(
    'operator' => 'in',
    'value' => array(
      'user' => 'user',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => 'type_op',
      'label' => 'Type',
      'use_operator' => 0,
      'identifier' => 'type',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 0,
    ),
    'id' => 'type',
    'table' => 'watchdog',
    'field' => 'type',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
));
$handler->override_option('items_per_page', 10);
$handler->override_option('use_pager', '0');
$handler->override_option('use_more', 1);
$handler->override_option('use_more_always', 1);
$handler->override_option('link_display', 'page_3');
$handler->override_option('style_options', array(
  'grouping' => '',
  'override' => 0,
  'sticky' => 0,
  'order' => 'desc',
  'columns' => array(
    'severity' => 'severity',
    'type' => 'type',
    'timestamp' => 'timestamp',
    'message' => 'message',
    'name' => 'name',
    'link' => 'link',
  ),
  'info' => array(
    'severity' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'type' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'timestamp' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'message' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'name' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'link' => array(
      'sortable' => 0,
      'separator' => '',
    ),
  ),
  'default' => '-1',
  'watchdog_table_severity' => 1,
  'watchdog_table_severity_emerg' => 'dblog-emerg',
  'watchdog_table_severity_alert' => 'dblog-alert',
  'watchdog_table_severity_critical' => 'dblog-critical',
  'watchdog_table_severity_error' => 'dblog-error',
  'watchdog_table_severity_warning' => 'dblog-warning',
  'watchdog_table_severity_notice' => 'dblog-notice',
  'watchdog_table_severity_info' => 'dblog-info',
  'watchdog_table_severity_debug' => 'dblog-debug',
));
$handler->override_option('block_description', '');
$handler->override_option('block_caching', -1);
$handler = $view->new_display('block', 'Overview Page not found', 'block_3');
$handler->override_option('filters', array(
  'type' => array(
    'operator' => 'in',
    'value' => array(
      'page not found' => 'page not found',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => 'type_op',
      'label' => 'Type',
      'use_operator' => 0,
      'identifier' => 'type',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 0,
    ),
    'id' => 'type',
    'table' => 'watchdog',
    'field' => 'type',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
));
$handler->override_option('items_per_page', 10);
$handler->override_option('use_pager', '0');
$handler->override_option('use_more', 1);
$handler->override_option('use_more_always', 1);
$handler->override_option('link_display', 'page_4');
$handler->override_option('style_options', array(
  'grouping' => '',
  'override' => 0,
  'sticky' => 0,
  'order' => 'desc',
  'columns' => array(
    'severity' => 'severity',
    'type' => 'type',
    'timestamp' => 'timestamp',
    'message' => 'message',
    'name' => 'name',
    'link' => 'link',
  ),
  'info' => array(
    'severity' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'type' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'timestamp' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'message' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'name' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'link' => array(
      'sortable' => 0,
      'separator' => '',
    ),
  ),
  'default' => '-1',
  'watchdog_table_severity' => 1,
  'watchdog_table_severity_emerg' => 'dblog-emerg',
  'watchdog_table_severity_alert' => 'dblog-alert',
  'watchdog_table_severity_critical' => 'dblog-critical',
  'watchdog_table_severity_error' => 'dblog-error',
  'watchdog_table_severity_warning' => 'dblog-warning',
  'watchdog_table_severity_notice' => 'dblog-notice',
  'watchdog_table_severity_info' => 'dblog-info',
  'watchdog_table_severity_debug' => 'dblog-debug',
));
$handler->override_option('block_description', '');
$handler->override_option('block_caching', -1);
$handler = $view->new_display('block', 'Overview PHP', 'block_4');
$handler->override_option('filters', array(
  'type' => array(
    'operator' => 'in',
    'value' => array(
      'php' => 'php',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => 'type_op',
      'label' => 'Type',
      'use_operator' => 0,
      'identifier' => 'type',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 0,
    ),
    'id' => 'type',
    'table' => 'watchdog',
    'field' => 'type',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
));
$handler->override_option('items_per_page', 10);
$handler->override_option('use_pager', '0');
$handler->override_option('use_more', 1);
$handler->override_option('use_more_always', 1);
$handler->override_option('link_display', 'page_5');
$handler->override_option('style_options', array(
  'grouping' => '',
  'override' => 0,
  'sticky' => 0,
  'order' => 'desc',
  'columns' => array(
    'severity' => 'severity',
    'type' => 'type',
    'timestamp' => 'timestamp',
    'message' => 'message',
    'name' => 'name',
    'link' => 'link',
  ),
  'info' => array(
    'severity' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'type' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'timestamp' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'message' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'name' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'link' => array(
      'sortable' => 0,
      'separator' => '',
    ),
  ),
  'default' => '-1',
  'watchdog_table_severity' => 1,
  'watchdog_table_severity_emerg' => 'dblog-emerg',
  'watchdog_table_severity_alert' => 'dblog-alert',
  'watchdog_table_severity_critical' => 'dblog-critical',
  'watchdog_table_severity_error' => 'dblog-error',
  'watchdog_table_severity_warning' => 'dblog-warning',
  'watchdog_table_severity_notice' => 'dblog-notice',
  'watchdog_table_severity_info' => 'dblog-info',
  'watchdog_table_severity_debug' => 'dblog-debug',
));
$handler->override_option('block_description', '');
$handler->override_option('block_caching', -1);
$handler = $view->new_display('block', 'Overview other', 'block_5');
$handler->override_option('filters', array(
  'type' => array(
    'operator' => 'not in',
    'value' => array(
      'content' => 'content',
      'page not found' => 'page not found',
      'php' => 'php',
      'user' => 'user',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => 'type_op',
      'label' => 'Type',
      'use_operator' => 0,
      'identifier' => 'type',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 0,
    ),
    'id' => 'type',
    'table' => 'watchdog',
    'field' => 'type',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
));
$handler->override_option('items_per_page', 20);
$handler->override_option('use_pager', '0');
$handler->override_option('use_more', 1);
$handler->override_option('use_more_always', 1);
$handler->override_option('link_display', 'page_6');
$handler->override_option('style_options', array(
  'grouping' => '',
  'override' => 0,
  'sticky' => 0,
  'order' => 'desc',
  'columns' => array(
    'severity' => 'severity',
    'type' => 'type',
    'timestamp' => 'timestamp',
    'message' => 'message',
    'name' => 'name',
    'link' => 'link',
  ),
  'info' => array(
    'severity' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'type' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'timestamp' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'message' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'name' => array(
      'sortable' => 0,
      'separator' => '',
    ),
    'link' => array(
      'sortable' => 0,
      'separator' => '',
    ),
  ),
  'default' => '-1',
  'watchdog_table_severity' => 1,
  'watchdog_table_severity_emerg' => 'dblog-emerg',
  'watchdog_table_severity_alert' => 'dblog-alert',
  'watchdog_table_severity_critical' => 'dblog-critical',
  'watchdog_table_severity_error' => 'dblog-error',
  'watchdog_table_severity_warning' => 'dblog-warning',
  'watchdog_table_severity_notice' => 'dblog-notice',
  'watchdog_table_severity_info' => 'dblog-info',
  'watchdog_table_severity_debug' => 'dblog-debug',
));
$handler->override_option('block_description', '');
$handler->override_option('block_caching', -1);
Comment #2

rstamm commented 20 August 2010 at 11:42
Suggestions for improvements are welcome
Comment #3

helmo commented 8 April 2013 at 14:03
Why not create this as a default view like https://drupal.org/project/admin_views does.
Comment #4

earthangelconsulting commented 29 May 2013 at 22:11
is there a newer example, for Views3/Drupal7 ?
Comment #5

rstamm commented 13 June 2013 at 19:18
for Views3/Drupal7 not yet.
Comment #6

earthangelconsulting commented 14 June 2013 at 18:01
just curious: if you have working module code for Views3/Drupal7, how could you not have an example? how were you able to test your code after porting it? :-)
Comment #7

helmo commented 24 February 2016 at 21:55
Version:	6.x-2.0	» 7.x-3.x-dev
Category:	Support request	» Feature request
Issue summary:	View changes
Status:	Active	» Needs review
Status	File	Size
new	how_to_create_the-879888-7.patch	12.83 KB
Here's a patch that adds a default view.
Comment #8

helmo commented 25 February 2016 at 15:43
Status	File	Size
new	how_to_create_the-879888-8.patch	13.21 KB
Minor improvement ... added Severity column and set the default sort to the timestamp.
Comment #9

earthangelconsulting commented 7 April 2017 at 22:11
re: #8... thanks helmo, that's very helpful indeed! :-)
How to create the watchdog listing per the example screenshot?

Comments

Comment #1

Comment #2

Comment #3

Comment #4

Comment #5

Comment #6

Comment #7

Comment #8

Comment #9

News items

Our community

Documentation

Drupal code base

Governance of community
