CiviCRM Community Forums (archive)

Hi folks,

I'm new here and not sure if this is the best place to go for support, or where on the Forums to place my question. Let me know if there's a more appropriate place for this question.

I have a site with a complex membership. I have five or six pages where I need to appended contact info at the bottom of the pages. On the Staff Drupal page, I need to append at the bottom a list of all Staff names, primary emails, and primary phones. On Group A page, I need a list of Group A leaders with names, primary emails, and primary phones. On Group B page, I need a list of Group B leaders with names, primary emails, and primary phones. And so on.

It's not clear to me how to go about this and my researching is leading me in complex circles or require big time investments for directions that I'm not sure will lead to my goal.

Drupal Views seems like my best bet. I've experimented with Drupal Views with mixed results. I am able to do a View for either Users or CiviCRM Contacts. For there I am able to used Relationship A-to-B and Relationship: B fields to pull the correct contacts out of the CiviCRM database. But I can't limit this view to just Primary emails and phone; no matter how I structure it, I get one result per email or phone number for that contact.

* Putting CiviCRM Phone Details: Is Primary Phone (True) in the Filters Criteria has no effect on reducing duplicates results; somehow almost all contact phone numbers (work, fax, cell) are listed and Primary phone numbers, even though only one has the radio button checked in the contact card. 

* Putting CiviCRM Phone Details: Is Primary Phone with value "Yes" in the Contextual Filters removes all results.

If there's a way to fix the duplicates in Views, or if there's another path I should look into, I would greatly appreciate advice. Thanks.

i suspect views is probably your best option for this w/o significant custom coding

however, u'll need to go in and debug and fix the views integration code so that it generates the right queries for is primary phone etc

lobo

Bump