CiviCRM Community Forums (archive)

Hello all,

I generally get awesome results building Drupal Views with CiviCRM data however sometimes I find the filter options to be lacking. For instance, I have a "CiviCRM Contacts" view that provides me with a display of a members roster and another of the organizations that the members belong to. It works perfectly however, I though I would add a CiviCRM Address: City/Region field so that people could find an organization based on their location. Unfortunately all I can do out of the box is put in a text field.

I've hacked together a dropdown with a DB query and a little custom code but I'd much rather use a proper filter like a dropdown (select) or an autofill text field. Are there any modules or extensions that will provide extended filters in views?

Thanks,
Andrew 

Alright... I'm on it. My "ad hoc" coded solution actually works quite well so I'll see if I can wrap it up into a module so that views knows it's there. I'll post back once I get something one can just plug in that works.   

Fantastic! Thanks Pete.

Absolutely!

I'll dig into civicrm/drupal/modules/views/civicrm and see if I can add a filter handler for city. I think that's probably the best way to do this. If not, let me know.

Andrew