CiviCRM Community Forums (archive)

I need to create a report based on age groupings, so I just want to allow for certain filters on Groups and Tags. However, it's showing up custom fields in the selection field. See the attachment for a screenshot.

If I could get the "Additional Fields" out of the Display section but keep it in the filter section, that would be totally excellent!

Here's my code

    protected $_customGroupExtends = array(
    'Contact', 'Individual'); function __construct() {
    $this->_columns = array(
      'civicrm_group' =>
      array(
        'dao' => 'CRM_Contact_DAO_Group',
        'alias' => 'cgroup',
        'filters' =>
        array(
          'gid' =>
          array(
            'name' => 'group_id',
            'title' => ts('Group'),
            'operatorType' => CRM_Report_Form::OP_MULTISELECT,
            'group' => TRUE,
            'options' => CRM_Core_PseudoConstant::group(),
          ),
        ),
      ),
    );

    $this->_tagFilter = TRUE;
    parent::__construct();
  }



If you have $_customGroupExtends = array('Contact', 'Individual') you will get the custom fields added in the criteria.
If you don't want those you will have to override addCustomDataToColumns and perhaps buildQuery or customDataFrom to get things to work just right.

Glad it worked Matthew