CiviCRM Community Forums (archive)

I am trying to set up a Drupal 7 view of new members in civicrm using a contextual filter based on state and am having 2 different issues that I can't find the answers for.  I have a regular filter of member status in new/current and would like to output display name and city.  This will be a content pane to be added with other information to build a state page using the panels module.

1. The view works okay with no argument, but when I add a state as an argument in the view's preview I get nothing returned.  Suggestions on what might be wrong?  I use contextual filters on other views (with drupal data only) and they work fine.

2. For every field I add, I get additional duplicates of the information.  For instance, if I just output the name and city, 2 instances of each user shows, but when I add the state, 4 instances of each user shows.  Is there a way to not show duplicates?

There is currently no official or unofficial maintainer of the drupal + views3 integration code base. Would be great if you are willing to look into it and potentially become a maintainer of that part of the code base

lobo

For anyone that stumbles upon this thread looking for answers, I figured out that in the advanced section of views, choose the distinct setting under Query settings to remove duplicates.

Regarding the state contextual filter, it is the state_province_id it is looking for, not the state name as the title would lead one to expect.  Not sure how to pass in the state id though, so help is still needed...