Problem/Motivation

When creating a view of Contacts, there is no way to list those Contacts' Relationships.

Steps to reproduce

Proposed resolution

Provide a views relationship plugin to join Contacts to their Relationships.

Remaining tasks

User interface changes

API changes

Data model changes

CommentFileSizeAuthor
#3 CRMModule_2202b.pdf247.75 KBpeterk900

Issue fork crm-3566240

Command icon Show commands

Start within a Git clone of the project using the version control instructions.

Or, if you do not have SSH keys set up on git.drupalcode.org:

About issue forks

Comments

jdleonard created an issue. See original summary.

jdleonard’s picture

jdleonard
he/him
Primary language English
Location Austin, Texas
commented
Assigned: Unassigned » jdleonard
peterk900’s picture

peterk900 commented
StatusFileSize
new CRMModule_2202b.pdf247.75 KB

Thanks.

I understand that this can't be done within Drupal using Views at present but, as the UI provides the information, it must be getting it from the database tables. Attached are screen shots showing the display from the url ../web/admin/content/crm/relationship which correctly shows Organisation - Employee links and also my attempts at SQL, outside of Drupal, to retrieve the same information. Pending the new relaease where this data can be displayed in a View, if anyone can correct my SQL so I can do this in an external app, that would be really helpful.
Thanks.

jdleonard’s picture

jdleonard
he/him
Primary language English
Location Austin, Texas
commented
Assigned: jdleonard » Unassigned
Status: Active » Closed (duplicate)

Closing this as a duplicate of the underlying Primary Entity Reference issue: #3576123: Views support for views relationships and boolean handlers for base fields

A proposed fix is available in that issue. @peterk900 would appreciate your help testing in that issue!

Now that this issue is closed, review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, credit people who helped resolve this issue.