• Registered: 2010-01-27
  • Posts: 15

Topic: Location List and custom field list

I am looking to use the location list and create a custom list for departments. Both lists will be substantial and will get added to periodically. Is there any way in either the front end or the back end database to keep these lists in alphabetical order.

  • Registered: 2010-01-27
  • Posts: 15

Re: Location List and custom field list

Just for reference i have figured this out. This can be done if you are using phpMyAdmin as your back end database. All you need to do is find the custom_field_value table that your drop down list is in. Then Cross refernece the custom_field_id in which case mine was 3 which replicated my "department" drop down custom list.

All i then needed to do was make sure in this table the "Sort by key" was custom_field_value_fkindex3 (ascending)

this will now enable anything added to the list in the future to be in alphabetical order.

Hope his helps