CiviCRM Community Forums (archive)

I notice that it's possible to export the view. Is there anyway to hack it when it's exported, then re-import it?

No.

Regarding your main question, yes, I don't think this can be done directly in a View, but you could certainly achieve it by customizing one of your view templates and fetching the data for Contact C using the CiviCRM API.

I do not think you can do this with Panels. I think you will need to write a bit of code.

(This is an old thread but seems to be the right place to finally answer this question for anyone else stuck on this problem. If I should have started a new topic for this please let me know and I will do that.)

I have been trying to set up a Drupal View of a multiple relationships in CiviCRM as the original poster was. The view I wanted was that showed a list of contacts that are provided services from the current user's employer, as below:

(current user) contact a => (is employed by) => organisation => (is a provider of) => contact c

I created a view of CiviCRM Contacts, and could not see a way of getting this relationship to display what I wanted without building a custom module. I solved this with a custom Drupal module and using the preprocess views hook to pass in the contextual filter. The filters are passed into the $args[] variable.

You also may need to enable multiple values in a contextual filter, if you have more than one relationship from Contact A to Contact B, in this case this is multiple employers of contact A. This is under Contextual Filters > Advanced > Allow multiple values. You do not add % to the path as you would normally do with a contextual filter as we are programmatically inserting it.

Create a custom Drupal module with the following code

/**
* @implements hook_views_pre_view().
*/
function my_module_views_pre_view(&$view, &$display_id, &$args){

if($view->name == "my_view") {
      // Check that we are altering the correct view based on and $view->name
      civicrm_initialize();
      require_once 'api/api.php';
      global $user;
      //get the matching civi id for the current user
      //This is using Civicrm version 4.4.6

      //first get the current user's Civicrm record
      $params = array(
         'version' => 3,
         'sequential' => 1,
         'uf_id' => $user->uid,
      );
      /*The contact ID is in $result['values'][0]['contact_id']*/
      $result = civicrm_api('UFMatch', 'get', $params);

      $params = array(
          'version' => 3,
          'sequential' => 1,
          'relationship_type_id' => 5, /*get your relationship ID from /civicrm/admin*/
          'contact_id_a' => $result['values'][0]['contact_id'],
      );
      $result = civicrm_api('Relationship', 'get', $params);

      //temp stores the string which will be passed to the $args[] array
      $temp = "";

      //loop through the a => b relationships, and append all the ids of contact b
      foreach ($result[values] as $key => $value ) {
         if ($key > 0)
            $temp .= "+";
         $temp .= $value['contact_id_b'];
      }
      // populate the $args contextual filters array with the ids.
      $args[] = $temp;
   }
}

Sounds great - I have no idea how you would do this daisy chaining though. Can you explain a bit more how this would work?

Thanks
Alex