CiviCRM Community Forums (archive)

for the core tables, the fields are inserted via manual specification. Check: drupal/modules/views/civicrm.views.inc

You can add support for postal code (and other missing fields). Please file an issue and then attach it as a patch

Most of the other tables, all the fields are added automatically by checking the table definition

lobo

Thank you both.

I have created an issue: http://issues.civicrm.org/jira/browse/CRM-4397

And uploaded the patch.  I tested it on my install and it worked but did not test it elsewhere.  Therefore it is still marked as "open" in case you have a more rigorous testing process.

Let me know if I can be of any other assistance in this matter.  It has fixed my issue and I hope it will help others.

likewise, looking for GROUP field in views.
Thanks,
Maria

Hi quick question on how do something in civicrm.views.inc

This CiviCRM file has a phone field, but if there are two phones at one location for instance... Home:Phone Home:Fax then this Views code will retrieve both phone numbers as 2 rows (and therefore as an array I think)... and mess up the Views display because Views isn't looking for an array, just a string.

How can I restrict it so that this code grabs the actual phone number of a certain type.  For instance

[phone_phone] = 999-999-9999
[phone_fax] = 999-999-4444

Or even I'd settle for pulling only the first phone number...

I tried looking into the handlers but they don't appear much as far as restricting the number of rows pulled.


    //FULL PHONE NUMBER
    $data['civicrm_phone']['phone'] = array(
                                            'title' => t('Phone Number'),
                                            'help' => t('Full Phone Number'),
                                            'field' => array(
                                                             'handler' => 'views_handler_field',
                                                             'click sortable' => TRUE,
                                                             ),

                                            'argument' => array(
                                                                'handler' => 'views_handler_argument',
                                                                ),

                                            'filter' => array(
                                                              'handler' => 'views_handler_filter_string',
                                                              ),

                                            'sort' => array(
                                                            'handler' => 'views_handler_sort',
                                                            ),
                                            );

    //TODO: Mobile Provider

    //PHONE TYPE  , Phone, Mobile, Fax or Pager
    $data['civicrm_phone']['phone_type'] = array(
                                                 'title' => t('Phone Type'),
                                                 'real field' => 'phone_type_id',
                                                 'help' => t('The Type, either Phone, Mobile, Fax or Pager'),
                                                 'field' => array(
                                                                  'handler' => 'civicrm_handler_field_phone_type',
                                                                  'click sortable' => TRUE,
                                                                  ),

                                                 'argument' => array(
                                                                     'handler' => 'views_handler_argument',
                                                                     ),

                       
                                                 'filter' => array(
                                                                   'handler' => 'civicrm_handler_filter_phone_type',
                                                                   ),

                                                 'sort' => array(
                                                                 'handler' => 'views_handler_sort',
                                                                 ),
                                                 );