TOPIC: [SOLVED] Why aren't locations coming up in order?

DT Register 2.7.10.

When I enter locations into the system, they do not show in up the dropdown the order in which I put them in. I went to the table and checked to make sure they ID numbers are in ascending order.

I'm not sure why DT register has chosen the order it has. It is not ascending or descending by ID or Name. I would've expected one or the other.

There's also no way to rearrange the order in the front end.

Help?

Is there an answer to this?

Upgrade to the new 2.7.11 and you'll find locations are now listed in alphabetical order.

i did upgrade but my locations are not coming up in alphabetical order. do i have to set something?

What we modified was all of the dropdown selections and filters that show the locations. Realizing we did not do this for the list of locations when MANAGING them. If this is what you are referring to, you can modify this file:
/administrator/components/com_dtregister/views/locations/tmpl/list.php

Towards the top of the file you'll find:

$sql = "Select SQL_CALC_FOUND_ROWS * from #__dtregister_locations";

Change it to:

$sql = "Select SQL_CALC_FOUND_ROWS * from #__dtregister_locations order by name";

Same can be done on the frontend locations management file if you are using the frontend Control Panel. Same directory, just not in the /administrator area.

The next package update will include this adjustment.

thank you. i will try that.