Views filter "is primary" filters out too much

[mariagwyn]

I am using views to create a member directory from CiviCRM data (It integrates better than the profile option, I think).  Currently, I have filters set to "is primary" for phone, address and email field.  I did this because without it, views was listing all address/phone options as multiple rows in a table.  I only want the primary available for viewing.

The problem is, if a record is missing a primary phone number, that record does not appear in the view.  In other words, the filter is not only filtering down to primary data, it is filtering OUT if any single piece of primary data is missing.  

Is there a way around this?

Cross post: http://forum.civicrm.org/index.php/topic,8743.0.html

[Donald Lobo]

i suspect there is, but u'll need to investigate a bit more into the views code and figure out how it can structure the query as a LEFT JOIN rather than an INNER JOIN

You might have to tweak the civicrm data definition arrays that it exposes to views

lobo