CiviCRM Community Forums (archive)

I presumed that:

"added by" = staff/data entry person
"with" = contact with whom the activity took place
"assigned to" = staff/contact that actually will enact the activity. If this field is blank, then the activity is enacted by "added by"

eg a phone call would have datakid as the "added by" (because I entered the data), funnyCam as the "with", because there will be a phone call _with_ funnyCam; and "assigned to" adam because adam will make the phone call
 
am I mistaken?

I added a new activity to a record (the "with" record), with the above data.

When I created a View, that included "contact email" and "display name" I got the details from the "added by" field instead of the expected "with" field.

From this I take it that the activity is primarily linked to the "added by" contact...yep, there it is, there are two other tables, civicrm_activity_assignment and civicrm_activity_target for what I want. Ok. How to get them into View?

I presume it's through a little wrangling of the ~/public_html/sites/all/modules/civicrm/drupal/modules/views/civicrm.views.inc to include the tables and their fields that I want?