Author Topic: Customization of Activity Report: Add Contact Field for Target (Read 616 times)

Detlev · April 02, 2015, 02:52:23 pm

We have a use case, where we need to display the current_employer field for the target contact (and also sort by that field).

I set up a customized report (using the recipe from the CiviCRM Cookbook) and was able to do certain customization tasks. However, adding other contact fields seems to be tricky...

Had anybody out there done something like that and could give me a hint?

Cheers,
Detlev

Erik Hommel · April 03, 2015, 09:18:00 am

I have not found it too tricky to add contact fields, you have to add them to the array of columns and check that they are set up in such a way that the SQL being build by the _select, _from and _where methods can actually pull them together correctly?
You might want to try a debug on your query in the postProcess method, just before the buildRows method is called.

Eileen · April 03, 2015, 06:10:00 pm

I don't know how far it takes you - but the extended reports extension has an activity report in it which allows some more control over the 3 sets of contact fields (target, source & assigned).

CiviCRM Community Forums (archive)

News:

Author Topic: Customization of Activity Report: Add Contact Field for Target (Read 616 times)

Detlev

Customization of Activity Report: Add Contact Field for Target

Erik Hommel

Re: Customization of Activity Report: Add Contact Field for Target

Eileen

Re: Customization of Activity Report: Add Contact Field for Target