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!
| Comment | File | Size | Author |
|---|---|---|---|
| webform_views_bug.jpg | 35.59 KB | investigacoes |