On Drupal 7, how would you display a list of CiviCRM activities and show the two types of contacts (the activity related to the client and the user who created the activity)?
Views is pretty tricky here. All the primary fields (Activity ID, Status, Type, Activity Date, Text Link) can be added without any problems. Each row in the table represents a unique activity entry. When it came to adding the names of the individuals for the client and person who created the activity, I'm having difficulty with it. I tried adding a relationship to "CiviCRM Activity Contacts: Activity Contact ID"; however, this will duplicate some of the activities in the data.
- Activity Assignees: Will not display the person who created the activity
- Activity Source: Displays the person who created the activity, but unclear how I would add the target contact (the client). Contact A/B doesn't work well.
- Activity Targets: Display the target contact (the client). Added a relationship successfully to display the user (person who created the activity), but one activity now appears in 9 rows.
The only way I can think of displaying a list of unique activities is possibly aggregating (Views "use aggregation"? Table with aggregation options module to group Activity IDs?). Am I thinking about this too much?