CiviCRM Community Forums (archive)

Hello,

I was looking if it was possible with views to show for example only the following fields: full address, phone, mobile, fax: all of the 'work' type. Right now with the Location type filter it shows the right address, but not the phone number (it still shows the 'home' number'). Therefore I can't use these results.

I also feel that I should be able to call the fields directly through the fields section and that I shouldn't have to select one general field (for example: 'phone number') and then filter them. Right now there is for example one field for 'phone number'. What If I need multiple phone numbers, all of different type? (home, work, billing, etc..) Or different types of phone numbers? (phone, mobile, fax..) I can't just use one filter to show all that.

I also noticed with views that my result is only one contact, but this result shows up 8 times. (one time for every field?) I can reduce it by setting the 'distinct' option, but I feel that I shouldn't even have to use it in the first place.

Screenshot of my view: http://dannyjoris.be/files/fora/civicrm-views.png

Thanks in advance!
Cheers,
Danny

Thanks for confirming the issue.

Unfortunately I'm not in a position right now to be able to contribute by code nor financially. I don't know the code enough - how many days (very roughly) would it take to add this functionality?

Right now I kind of worked around this issue by using mainly custom data fields which I can call with views directly. I'm not using the built-in fields because of this.

Cheers,
Danny

It looks like what is needed is a "group by" type option.

Right now if you have multiple phone numbers for a person, you get that person listed in the view as many times as they have phone numbers. So then you need to turn on "distinct".

When you turn on distinct you lose all of the other phone numbers except the first one.

I guess what I'll do in the meantime is add a custom field for the fax number instead of using a phone field since I can't show it and the work number.