CiviCRM Community Forums (archive)

In civi's drupal views implementation (3.2.0), it seems
that it isn't possible to make a view that includes both
Individual custom data and Membership custom data.
E.g., you can create a Contacts view that shows Individual
custom data and core Membership data, but Membership
custom fields aren't available in the field select.

Attached is a patch to make all custom data available in
both Contacts and User views in drupal.

It's only barely tested with Membership custom data, but
it seems to work. I'm not sure if it should be limited
to just some types of custom data (Memberships + ...?) ?

I'm also wondering if it wouldn't be better to use
views "relationships" rather than joins (but joins is
is the strategy the current implementation is using).

Is this the right place to post things like this? :)

Thanks.

- Rob

It's two steps:

1. join custom data to parent entity (the original code).
2. also join to contacts via the parent entity (which only works if
the parent entity table is already joined to civicrm_contact,
as it is for civicrm_membership, and I assumed others).

Sounds like I should limit the second join to memberships
and maybe contributions (both of which have a  'contact_id'
field in the entity table) ?