Remember sort order

[TheFatherMind]

First of all I would like to thank you for sharing this great app and tell you that it is the best one I have seen so far for pdns.

Why is the default sort order by ID? That would make sense for a computer but not for a human. A human is going to look down a list for a username or domain name in alphabetical order. To me.. it all just looks scrambled and random. Is there a way to make this sort alpha by default? I am perfectly fine with hacking the code if you direct me to the right spots and give me a clue as to how to change it.

Note: I know I can click the top of the column and make it sort there. But that setting is not remembered when I return to the page and I am having to click that obsessively. This is counter to the general function/purpose of a computer.

Thank you again!!

[loewexy]

I think we can change that in v2.0 so that it remembers you last sort order.

For a temporary workaround:
I think that the sorting by ID is just the default from the database. If you do not sort explicitly by something no ORDER BY is added to the query and the database is free to return whichever it likes.
In api/domains.php in line 84 is the logic for the sorting. So you could add an else here, and append ORDER BY name ASC to the query.

Same in api/edit-master.php line 64 for the records.

Hope that helps you in the meantime.

[SpaceJelly]

What would be nice would be to sort by Type, then Name. That way records would be grouped logically by Type. My code for domains.php (Though only really need name on this but doesn't hurt to sort by type too if you have multiples.)

Line 101. replace:
}
with:

    } else {
            $sql .= "ORDER BY type ASC, name ASC";
    }

for edit-master.php
Line 82. replace:
}
with:

    } else {
            $sql .= "ORDER BY type ASC, name ASC, priority ASC";
    }

Added priority into edit-master.php for the MX records :)

Those are my tweaks, thanks for the tips on where to find the search bits!

[TheFatherMind]

@loewexy and @SpaceJelly thank you for the tips! Good directions! I did exactly as instructed and have the exact results I was hoping for.

For anyone reading this thread I would like to add to that with one more edit I made. To make the users list sort in alpha by default do the following...

edit api/users.php
line 52. replace:
}
with

      } else {
        $sql .= "ORDER BY name ASC";
      }

Unless you want to group your admins then you should do this...

edit api/users.php
line 52. replace:
}
with

      } else {
        $sql .= "ORDER BY type ASC, name ASC"";
      }

[DesktopMasters]

Greetings! I would like to do this. However the above information does not seem to apply to the existing code. What do I hack to make it remember the sort order for the domains in the list, as well as the records and users?