I would like to generate an Activities report (eg upcoming scheduled activities) which includes case data (eg case ID, case Subject, case Role contacts, case custom fields) of the case to which each listed activity relates. Is there an 'approved' way of doing this? Thanks.
1 Answer
Are you using drupal? You might get what you want with a drupal view.
The "extended report" extension (https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport) has a case pivot report where you can filter on activity date for example. It might get you close.
A sideways thought: You mention upcoming scheduled so I assume there is a further end use for this report, which might be achievable other ways. For example scheduled reminders or civirules might be able to give advance notice when certain conditions are met.
-
Using Joomla, so no view option. But Eileen's Extended Report extension looks very promising. Thank you.– JernCommented Feb 16, 2019 at 19:52
-
-
Thanks. Yes, we're using scheduled reminders as well, and civirules. In order to include case-related data in the reminders, I've added read-only custom fields to the activities, and a hook to add the case data to the activity when the activity is created. It's clunky but it sort of works. We can also use it to include case data in activity reports. But it's not a long-term solution. We don't have any way of syncing the activity case fields with the case data, for example. So I was hoping to find a better solution, at least for the reports.– JernCommented Feb 17, 2019 at 8:08
-
I suppose what we ideally need is some kind of back-link field in the activity, which would fetch the case data dynamically. Maybe a field which contains an API call.– JernCommented Feb 17, 2019 at 8:23
-
If you're comfortable with exporting to excel and cross-referencing, e.g. with VLOOKUP, it's not too hard to add case id to the Activity Detail civireport, and then you can export it and a regular case detail report and cross-ref. This is very lightly tested but see gist.github.com/demeritcowboy/6a0654160fd78ef5899698324561830d.– DemeritCommented Feb 17, 2019 at 15:09