CiviCRM Community Forums (archive)

Hi Folks,

Civi projects are continuing to progress but I have ran into the same issue in two separate projects. How does one populate the select box of activities in the filter section of a report?

The select box appears to be populated by the following code block.
 
array( 'title'        => ts( 'Activity Type' ),
          'operatorType' => CRM_Report_Form::OP_MULTISELECT,
          'options'      => CRM_Core_PseudoConstant::activityType(), ),

Looking at the database I can find no flag that would indicate which activities are added to the above array. This post, http://forum.civicrm.org/index.php/topic,6531.msg28793.html#msg28793 indicates that the filter field in the civicrm_option_value table makes this feat happen but on the current version there appears to be nothing special about it.

This post http://forum.civicrm.org/index.php/topic,6565.msg28936.html#msg28936 offers a clue showing that the activity search shows custom activities but offers no solution but to upgrade.

So, how does one get a custom activity to appear in the report?

Thank you 

Thanks for the link Kurund. I followed that documentation to create my custom report from which my problem stems. Adding custom fields populates the columns that I can select for the report, but the activities do not get added to the select box.

Thanks again.

Stoob: No reason not to state the obvious. Sometimes that is the key. I am using the $_customGroupExtends with Activity.

protected $_customGroupExtends = array( 'Individual', 'Activity'  );
Should I instead be using the word, 'Activities'? I forget who it was on the IRC channel, but they helped me get the customGroupExtends working.

If I print_r($this->_columns); I get a listing of all returned fields. No custom activities though. So, maybe I am just asking for the wrong set of data when I use the word 'Activity'.

Activity is the proper key to use. This allows me to filter and select all of the options which are a part of my custom activity named "Leave Hours." However, you cannot filter by the activity "Leave Hours" because it is not populated in the Activity Type select box.

I am sure I will be able to create the reports I need with the activities added as they are now, but it seems improper for custom activities not to be added to the main activity filter.

Thanks Stoob.