I need to create a Drupal view (CiviCRM contacts) displaying the staff of an organisation. The view has the relationship CiviCRM contact <-> Drupal user enabled. This seems to be required to be able to display the Drupal user images.
Now comes the tricky part: The Drupal site where the view is created is an offspring of a CiviCRM multi-site setup. This means staff members usually have a Drupal account for domain 1 (the central CiviCRM) and domain 2 (the multi-site offspring where the Drupal view lives). In the DB this means they have 2 records in
civicrm_uf_match. Now if the relationship is enabled AND the user image field is included, the view displays those contacts twice. Removing the relationship results in losing the user images.
Any clues to a solution would be very welcome.