views integration question

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

views integration question

Sofia Robb
Hello!

I created a materialized view. Success!
I copied my schema description and used to import as a views integration. Success!
I 'drushed cc all'
I cleared my browser cache.

I did all the above but I do not see my table in the relationships in my view. i have done this before as was successful. I think I am not missing anything. But I guess I am.

What did I not do?

Thanks,
Sofia



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Gmod-tripal mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-tripal
Reply | Threaded
Open this post in threaded view
|

Re: views integration question

Kucheran, Lacey Sanderson
Hi Sofia :-)

When creating your views integration did you add “Joins & Relationships” (see collapsed fieldset at the bottom of the views integration page) between your materialized view and the table your Drupal View is built on? 

Bonus Information:
Checking the “Relationship Only” checkbox will ensure the relationship shows up in the “Add Relationships” pane on the Drupal Views UI. Not checking it will add the join automatically and just make those fields show ip in the field list on your Drupal View. I suggest checking that checkbox since it gives you more control over the join and causes less conflicts.

~Lacey

------------------------------------------------------
Lacey-Anne Sanderson
Bioinformaticist
Pulse Crop Breeding and Genetics
Phone: (306) <a href="tel://966-3208">966-3208
Room 2C33 Agriculture
Department of Plant Sciences
University of Saskatchewan

On February 9, 2017 at 12:03:27 PM, Sofia Robb ([hidden email]) wrote:

Hello!

I created a materialized view. Success!
I copied my schema description and used to import as a views integration. Success!
I 'drushed cc all'
I cleared my browser cache.

I did all the above but I do not see my table in the relationships in my view. i have done this before as was successful. I think I am not missing anything. But I guess I am.

What did I not do?

Thanks,
Sofia


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot_______________________________________________
Gmod-tripal mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-tripal

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Gmod-tripal mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-tripal
Reply | Threaded
Open this post in threaded view
|

Re: views integration question

Sofia Robb
I did add relationships. Did I add them correctly? Here is my schema. I see my feature_id in the "joins and relationships"  area at the bottom of the integration. When i select the "relationship only" check box and save for the feature_id relationship, i get a lot of horrible looking errors and now my integration page is blank (see bottom of email). you said that my new columns should show up in my fields drop down in my view automatically if i don't select this option. They are not there, i have done something super wrong i guess.


array (
  'table' => 'chado_expression_signals',
  'name' => 'Chado Tripal_Expression Signals',
  'type' => 'mview',
  'description' => ' ',
  'priority' => '10',
  'base_table' => '1',
  'fields' => array (
    'feature_id' => array (
      'name' => 'feature_id',
      'title' => 'Feature Id',
      'description' => 'Feature Id',
      'type' => 'int',
      'handlers' => array (
        'field' => array (
          'name' => 'views_handler_field_numeric',
        ),
        'filter' => array (
          'name' => 'views_handler_filter_numeric',
        ),
        'sort' => array (
          'name' => 'views_handler_sort',
        ),
        'argument' => array (
          'name' => 'views_handler_argument_numeric',
        ),
      ),
      'joins' => array (
        'feature' => array (
          'feature_id' => array (
            'table' => 'feature',
            'field' => 'feature_id',
            'handler' => 'views_handler_join',
          ),
        ),
      ),
    ),
    'name' => array (
      'name' => 'name',
      'title' => 'Name',
      'description' => 'Name',
      'type' => 'varchar',
      'handlers' => array (
        'field' => array (
          'name' => 'views_handler_field',
        ),
        'filter' => array (
          'name' => 'tripal_views_handler_filter_select_string',
        ),
        'sort' => array (
          'name' => 'views_handler_sort',
        ),
        'argument' => array (
          'name' => 'views_handler_argument_string',
        ),
      ),
      'joins' => array (
      ),
    ),
    'signals' => array (
      'name' => 'signals',
      'title' => 'signals',
      'description' => 'list of signals',
      'type' => 'text',
      'handlers' => array (
        'field' => array (
          'name' => 'views_handler_field',
        ),
        'filter' => array (
          'name' => 'tripal_views_handler_filter_select_string',
        ),
        'sort' => array (
          'name' => 'views_handler_sort',
        ),
        'argument' => array (
          'name' => 'views_handler_argument_string',
        ),
      ),
      'joins' => array (
      ),
    ),
    'biomaterials' => array (
      'name' => 'biomaterials',
      'title' => 'biomaterials',
      'description' => 'list of biomaterials',
      'type' => 'text',
      'handlers' => array (
        'field' => array (
          'name' => 'views_handler_field',
        ),
        'filter' => array (
          'name' => 'tripal_views_handler_filter_select_string',
        ),
        'sort' => array (
          'name' => 'views_handler_sort',
        ),
        'argument' => array (
          'name' => 'views_handler_argument_string',
        ),
      ),
      'joins' => array (
      ),
    ),
  ),
)


  • Notice: Undefined index: mview_id in tripal_views_integration_form_validate() (line 1122 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: mview_id in tripal_views_integration_form_submit() (line 1168 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_readable_name_chado_expression_signals-1 in tripal_views_integration_form_submit() (line 1261 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_description_chado_expression_signals-1 in tripal_views_integration_form_submit() (line 1262 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_filter_handler_chado_expression_signals-1 in tripal_views_integration_form_submit() (line 1271 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_field_handler_chado_expression_signals-1 in tripal_views_integration_form_submit() (line 1271 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_sort_handler_chado_expression_signals-1 in tripal_views_integration_form_submit() (line 1271 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_argument_handler_chado_expression_signals-1 in tripal_views_integration_form_submit() (line 1271 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_readable_name_chado_expression_signals-2 in tripal_views_integration_form_submit() (line 1261 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_description_chado_expression_signals-2 in tripal_views_integration_form_submit() (line 1262 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_filter_handler_chado_expression_signals-2 in tripal_views_integration_form_submit() (line 1271 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_field_handler_chado_expression_signals-2 in tripal_views_integration_form_submit() (line 1271 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_sort_handler_chado_expression_signals-2 in tripal_views_integration_form_submit() (line 1271 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_argument_handler_chado_expression_signals-2 in tripal_views_integration_form_submit() (line 1271 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_readable_name_chado_expression_signals-3 in tripal_views_integration_form_submit() (line 1261 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_description_chado_expression_signals-3 in tripal_views_integration_form_submit() (line 1262 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_filter_handler_chado_expression_signals-3 in tripal_views_integration_form_submit() (line 1271 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_field_handler_chado_expression_signals-3 in tripal_views_integration_form_submit() (line 1271 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_sort_handler_chado_expression_signals-3 in tripal_views_integration_form_submit() (line 1271 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_argument_handler_chado_expression_signals-3 in tripal_views_integration_form_submit() (line 1271 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_readable_name_chado_expression_signals-4 in tripal_views_integration_form_submit() (line 1261 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_description_chado_expression_signals-4 in tripal_views_integration_form_submit() (line 1262 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_filter_handler_chado_expression_signals-4 in tripal_views_integration_form_submit() (line 1271 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_field_handler_chado_expression_signals-4 in tripal_views_integration_form_submit() (line 1271 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_sort_handler_chado_expression_signals-4 in tripal_views_integration_form_submit() (line 1271 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).
  • Notice: Undefined index: fields_argument_handler_chado_expression_signals-4 in tripal_views_integration_form_submit() (line 1271 of /var/www/html/sites/all/modules/tripal/tripal_views/includes/tripal_views_integration_UI.inc).


On Thu, Feb 9, 2017 at 11:15 AM, Kucheran, Lacey Sanderson <[hidden email]> wrote:
Hi Sofia :-)

When creating your views integration did you add “Joins & Relationships” (see collapsed fieldset at the bottom of the views integration page) between your materialized view and the table your Drupal View is built on? 

Bonus Information:
Checking the “Relationship Only” checkbox will ensure the relationship shows up in the “Add Relationships” pane on the Drupal Views UI. Not checking it will add the join automatically and just make those fields show ip in the field list on your Drupal View. I suggest checking that checkbox since it gives you more control over the join and causes less conflicts.

~Lacey

------------------------------------------------------
Lacey-Anne Sanderson
Bioinformaticist
Pulse Crop Breeding and Genetics
Phone: (306) <a href="tel://966-3208" target="_blank">966-3208
Room 2C33 Agriculture
Department of Plant Sciences
University of Saskatchewan

On February 9, 2017 at 12:03:27 PM, Sofia Robb ([hidden email]) wrote:

Hello!

I created a materialized view. Success!
I copied my schema description and used to import as a views integration. Success!
I 'drushed cc all'
I cleared my browser cache.

I did all the above but I do not see my table in the relationships in my view. i have done this before as was successful. I think I am not missing anything. But I guess I am.

What did I not do?

Thanks,
Sofia


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot_______________________________________________
Gmod-tripal mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-tripal


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Gmod-tripal mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-tripal