CiviCRM + Drupal Views: Filter options... dropdown, autofill?

[awasson]

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 

[petednz]

I don't think so, so would be awesome if you could apply your apparent talents to extending the civicrm-views integration work

[awasson]

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.   

[petednz]

great - andrew i have asked chris to pop in here in case he can help provider any pointers since he has contributed a fair bit to the Views work in the past

[awasson]

Fantastic! Thanks Pete.

[Chris Burgess]

@awasson - I'd say let's make this a patch to CiviCRM, rather than splitting it out into a module. Would you like to upload your current work to https://github.com/awasson so we can work from there on getting it into core?

[awasson]

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

[Chris Burgess]

Sounds good! Shout out if you need any pointers. Usually in IRC.