Hello Drupal-people!

Here's the problem: I have 2 webforms in my website. The created view is showing submissions from both forms, the wrong ones as empty spaces... Attached a printscreen and the export is below.

What have I done to mess it up?

$view = new view;
$view->name = 'Database_Ecologia';
$view->description = '';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'webform_submissions';
$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', 'Padrões', 'default');
$handler->override_option('relationships', array(
  'sid' => array(
    'id' => 'sid',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'sid',
  ),
));
$handler->override_option('fields', array(
  'sid' => array(
    'label' => 'Sid',
    '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,
    'set_precision' => FALSE,
    'precision' => 0,
    'decimal' => '.',
    'separator' => ',',
    'prefix' => '',
    'suffix' => '',
    'exclude' => 1,
    'id' => 'sid',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'sid',
    'relationship' => 'none',
  ),
  'submitted' => array(
    'label' => 'Submitted',
    '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' => 'custom',
    'custom_date_format' => 'j.n.Y-G:H',
    'exclude' => 1,
    'id' => 'submitted',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'submitted',
    'relationship' => 'sid',
  ),
  'uid' => array(
    'label' => 'Uid',
    '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,
    'set_precision' => FALSE,
    'precision' => 0,
    'decimal' => '.',
    'separator' => ',',
    'prefix' => '',
    'suffix' => '',
    'exclude' => 1,
    'id' => 'uid',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'uid',
    'relationship' => 'none',
  ),
  'escola' => array(
    'id' => 'escola',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'escola',
  ),
  'data_coleta' => array(
    'id' => 'data_coleta',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'data_coleta',
  ),
  'hora' => array(
    'id' => 'hora',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'hora',
  ),
  'municipio' => array(
    'id' => 'municipio',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'municipio',
  ),
  'local' => array(
    'id' => 'local',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'local',
  ),
  'climaticas' => array(
    'id' => 'climaticas',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'climaticas',
  ),
  'temperatura_ar' => array(
    'id' => 'temperatura_ar',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'temperatura_ar',
  ),
  'temperatura_agua' => array(
    'id' => 'temperatura_agua',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'temperatura_agua',
  ),
  'amonia' => array(
    'id' => 'amonia',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'amonia',
  ),
  'cloretos' => array(
    'id' => 'cloretos',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'cloretos',
  ),
  'cloro' => array(
    'id' => 'cloro',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'cloro',
  ),
  'dqo' => array(
    'id' => 'dqo',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'dqo',
  ),
  'dureza' => array(
    'id' => 'dureza',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'dureza',
  ),
  'ferro' => array(
    'id' => 'ferro',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'ferro',
  ),
  'fosfato' => array(
    'id' => 'fosfato',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'fosfato',
  ),
  'oxigenio' => array(
    'id' => 'oxigenio',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'oxigenio',
  ),
  'saturacao' => array(
    'id' => 'saturacao',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'saturacao',
  ),
  'ph' => array(
    'id' => 'ph',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'ph',
  ),
  'coliformes_fecais' => array(
    'id' => 'coliformes_fecais',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'coliformes_fecais',
  ),
  'coliformes_totais' => array(
    'id' => 'coliformes_totais',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'coliformes_totais',
  ),
  'salmonela' => array(
    'id' => 'salmonela',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'salmonela',
  ),
  'observacoes_adicionais' => array(
    'id' => 'observacoes_adicionais',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'observacoes_adicionais',
  ),
));
$handler->override_option('sorts', array(
  'submitted' => array(
    'order' => 'DESC',
    'granularity' => 'second',
    'id' => 'submitted',
    'table' => 'webform_views_ecologia_das_guas_parmetros',
    'field' => 'submitted',
    'relationship' => 'none',
  ),
));
$handler->override_option('access', array(
  'type' => 'none',
));
$handler->override_option('cache', array(
  'type' => 'none',
));
$handler->override_option('style_plugin', 'table');
$handler = $view->new_display('page', 'Página', 'page_1');
$handler->override_option('path', 'parametros');
$handler->override_option('menu', array(
  'type' => 'none',
  'title' => 'Banco de dados 2011',
  'description' => '',
  'weight' => '0',
  'name' => 'secondary-links',
));
$handler->override_option('tab_options', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
  'name' => 'navigation',
));

Thank you!

CommentFileSizeAuthor
webform_views_bug.jpg35.59 KBinvestigacoes