CiviCRM Community Forums (archive)

In recent versions, the locations are sorted by:

Address Name, Address City, Address "Street Address"

which seems a bit logical

lobo

Hi Dallas - It's a bit tough to come up with a sort for this dropdown that works nicely for a wide variety of users :-( The current sort order - see line 1594 in CRM/Event/BAO/Event.php - is:

ORDER BY sp.name, ca.city, ca.street_address ASC

... i.e. State followed by City followed by Street Address. And looking at your screen print - that's how it's sorted. This works nicely for organizations with event venues scattered across lots of states and cities. However for your situation it's not great. Initially I couldn't think of a non-hack way to change it for your needs - but then I realized you could probably use jQuery to change the select list sort. I did a quick search for that and came up with several examples. Not sure  this is the best / easiest - but it worked for me in a quick experiment.

The best part is you can append this to the template using the new 'append custom code to template' feature so it should be pretty future proof and easy to maintain. You'll be creating CRM/Event/Form/ManageEvent/Location.extra.tpl in your custom templates tree, with the jQuery code below (or some variation) in the file.

http://civicrm.org/blogs/dave-greenberg/now-its-easier-add-custom-behaviors-templates

{literal}
<script>
    // get the select
    var $dd = $('#loc_event_id');
    if ($dd.length > 0) { // make sure we found the select we were looking for

        // save the selected value
        var selectedVal = $dd.val();

        // get the options and loop through them
        var $options = $('option', $dd);
        var arrVals = [];
        $options.each(function(){
            // push each option value and text into an array
            arrVals.push({
                val: $(this).val(),
                text: $(this).text()
            });
        });

        // sort the array by the text
        arrVals.sort(function(a, b){
            return a.text == b.text ? 0 : a.text < b.text ? -1 : 1;
        });

        // loop through the sorted array and set the text/values to the options
        for (var i = 0, l = arrVals.length; i < l; i++) {
            $($options[i]).val(arrVals[i].val).text(arrVals[i].text);
        }

        // set the selected value back
        $dd.val(selectedVal);
    }
</script>
{/literal}