I have created a Drupal view which is used to show any emails sent through CiviCRM to the currently logged in contact. To list the emails, the view shows activities for that contact where the activity type = 'email'. I am able to show the title, subject, details and date and the view works fine. However, everytime I try to add in the Activity Source Contact field, suddenly the view has no results. I am assuming that the Activity Source Contact field is the 'Added By' field in CiviCRM for the activity (which is the 'From' field for the email)? If it is, I can't understand why suddenly the view has no results when I add the field.
The other strange thing is, in the Activity Source contact field settings in the view, there is a numeral formatter, which is strange for a text field. See the attached image.
Can anyone suggest how I can display the Activity "Added by" field in the Drupal view?