I'm trying to create a view of users and list the users' related Redhen Contact and Membership. The only relationships available in views to the Drupal user account are to the related Contact's AUTHOR, related Membership's AUTHOR, related Organization's AUTHOR. This doesn't make much sense to me. I'm assuming, it's supposed to be the the actual related Contact, Membership, or Organization, not the author of the information. Any chance on making the Contact, Membership, and Organization data available in a view of Drupal user accounts?
Thanks,
Mickey
| Comment | File | Size | Author |
|---|---|---|---|
| #10 | redhen_contact_views_relationships-1757574-10.patch | 3.25 KB | tauno |
| #8 | redhen_contact_views_relationships-1757574.patch | 2.11 KB | marktfrey |
Comments
Comment #1
tauno commentedThis is missing in redhen_contact since we moved to storing the drupal user connection in a different table. Need to either implement our own views relationship handler or figure out if there's a cleaner way within the entityPropertyInfo definitions.
Comment #2
tauno commentedAdded in commit 45c79f1 using joins. We may need to consider using a relationship instead of this is too rigid.
Comment #3
micnap commentedYayyyyy!!!! Thank you!!!!
Mickey
Comment #5
visuaLatte commentedI've installed RedHen beta3, and it's still not quite working correctly.
What I can do:
I can add a Views field of 'User: UID', 'User: Name', or other core User attributes without needing the Author_UID relationship. So this part works.
What still seems to be missing:
I can't add User fields (i.e. custom fields I've added to each User, such as a 'First Name' field) to Views without using the Author_UID relationship.
Comment #6
visuaLatte commentedRe-opened, sorry, forgot the first time.
Comment #7
visuaLatte commentedMy team member has written a patch to add a Views Relationship from RedHen Contact to User.
We'll post a patch here.
Comment #8
marktfrey commentedThis ^. I was able to access some user fields through the join, but could not establish any relationships other than the relationship on author_uid. Attached patch adds relationships from redhen_contact -> user and vice versa.
Comment #9
seanberto commentedAssigning to Tauno, who's on vacation this week. FYI, we're sprinting on a big custom (and private) Drupal/RedHen/Salesforce distribution for a client the next two weeks. It's leading to a lot of bug fixes and enhancements, but it's got us a bit backed up on the issue queue. Thank you for your patience. Mark and Nate and Mickey, we definitely value your input, patches and documentation. Thank you so much for partnering with us!
Comment #10
tauno commentedSeems like we could remove a couple of the join definitions and just rely on the relationships instead. Does this slightly tweaked patch work for you all?
Comment #11
tauno commentedAdded in commit 690a286. Thanks for the patch marktfrey!