Author Topic: Create a View showing both sides of a CiviCRM Relationship (Read 561 times)

Lionsharz · October 09, 2013, 07:10:24 am

Hi

Anyone know how to create a View that exposes contacts on both sides of a civicrm relationship? I have

Relationship Contact A = Accommodation Providers
Relationship Contact B = Guests

I want to expose these in Drupal Views to show all the guests who are related to an accomm provider.

Thanks!

petednz · October 09, 2013, 12:35:03 pm

Sorry I can't give you more details but we have done some improvements to the way Views deals with Relationships so you can choose which end you are working from. This will come out with 4.4 I believe.

But currently you should be able to do what you want YOu need to open the Advanced section in View, and add a Relationship for the Relationship concerned and then use that to specify that a second column of eg Display Name uses the Relationship you just created.

not sure if that is clear enough but may get you started

Lionsharz · October 10, 2013, 06:23:05 am

Hi Peter

Thanks a million - I followed that and got it to work eventually. Just spent time on simplifying the number of fields in the view. I found it helpful to use just two fields and change their Relationship type within the view until I got the results I wanted.

Cheers!

CiviCRM Community Forums (archive)

News:

Author Topic: Create a View showing both sides of a CiviCRM Relationship (Read 561 times)

Lionsharz

Create a View showing both sides of a CiviCRM Relationship

petednz

Re: Create a View showing both sides of a CiviCRM Relationship

Lionsharz

Re: Create a View showing both sides of a CiviCRM Relationship