CiviCRM Community Forums (archive)

This is a followup/related post to my last one about limiting the state/province based on the country selected in an exposed filter (http://forum.civicrm.org/index.php/topic,15828.0.html).

Often you'll want to include every country (via civi's administer >> configure >> global settings >> localization), because you want those countries available for new users, etc.  But when using a drupal view with an exposed country filter, you only want to show the countries that have been used.  Why show "Tuvalu" in the exposed filter, only to have a user select it and have no results?  This code fixes that:

/civicrm/drupal/modules/views/civicrm/civicrm_handler_filter_country.inc:
        /* code to limit the options of countries to only
         * display countries that have been used by contacts
         */
   
        // get the distinct list of countries used
        $result = db_query('SELECT DISTINCT country_id FROM {civicrm_address}');
        $countries = array();
        while ($row = db_fetch_array($result)) $countries[$row['country_id']] = $row['country_id'];
        // filter down to an intersect of the full list and the used list
        $this->value_options = array_intersect_key($this->value_options, $countries);

insert the code at line 59, after the if block, but before the end of the get_value_options() function.

x - if you expose a filter in Views you will end up with a list of all states - I think this approach is meant to limit the list to only those states for countries that have been selected in civicrm - his other fix on other thread is exactly what i need for a client where I have been through selecting just those countries in Views to show if they have actually been used for any contacts

great help for me, thanks j.