CiviCRM Community Forums (archive)

I would like to add the phone field to the Pledged but not Paid report. I just need to have the contacts phone number listed in the report.

I have tried adding it to the php file, but keep getting a db error "no such field exists"

I am sure that this is probably a simple problem, but I am new to CiviCRM and php. Any help is greatly appreciated.

Hello immanuel,

try below patch, will work for you.
Index: CRM/Report/Form/Pledge/Pbnp.php
===================================================================
--- CRM/Report/Form/Pledge/Pbnp.php (revision 29469)
+++ CRM/Report/Form/Pledge/Pbnp.php (working copy)
@@ -124,6 +124,12 @@
                           array( 'email' => null),
                           'grouping'=> 'contact-fields',
                           ),
+                   'civicrm_phone' =>
+                   array( 'dao'    => 'CRM_Core_DAO_Phone',
+                          'fields' =>
+                          array( 'phone' => null),
+                          'grouping'=> 'contact-fields',
+                          ),
                    
                    'civicrm_group' =>
                    array( 'dao'    => 'CRM_Contact_DAO_Group',
@@ -161,7 +167,10 @@
                             $this->_emailField = true;
                         } else if ( $tableName == 'civicrm_email' ) {
                             $this->_emailField = true;  
+                        } else if ( $tableName == 'civicrm_phone' ) {
+                            $this->_phoneField = true;  
                         }                    
                         $select[] = "{$field['dbAlias']} as {$tableName}_{$fieldName}";
                         $this->_columnHeaders["{$tableName}_{$fieldName}"]['type'] = CRM_Utils_Array::value( 'type', $field );
                         $this->_columnHeaders["{$tableName}_{$fieldName}"]['title'] = CRM_Utils_Array::value( 'title', $field );
@@ -202,6 +211,13 @@
                            {$this->_aliases['civicrm_email']}.contact_id) AND
                            {$this->_aliases['civicrm_email']}.is_primary = 1\n";    
         }
+        if ( $this->_phoneField ) {
+            $this->_from .= "
+            LEFT  JOIN civicrm_phone {$this->_aliases['civicrm_phone']}
+                       ON ({$this->_aliases['civicrm_contact']}.id =
+                           {$this->_aliases['civicrm_phone']}.contact_id) AND
+                           {$this->_aliases['civicrm_phone']}.is_primary = 1\n";    
+        }
     }      
    

Hope this helps.

Rahul.