I'm adding in about 20 tables from an external database. When they're done importing they show up with Z on the top and A on the bottom. I can click the column to re-sort them but it's a bit annoying.

Comments

mikeryan’s picture

Title: Tables added in reverse-alphabetical order » Sort by both connection and tablename
Assigned: Unassigned » mikeryan
Category: bug » feature

When you only have your Drupal database, tables are sorted by tablename. With external databases, the list is sorted by connection. I'd like to secondarily sort by tablename, but never worked out a way to do that through theme_table(). Maybe I'm stupid:-)...

Seriously, just confirmed (been a while since I checked it), if I set both the Connection and Table Name headers to 'sort' => 'asc', it's sorted by table name without regard to connection. I recall tracing through this and it seemed that theme_table only supports a single sort column. So, is there a way through the table theming support to have the inital sort happen by two columns?

Scratch that, no reason I can't generate an explicit ORDER BY clause when initially coming in, give me a minute here....

mikeryan’s picture

Status: Active » Fixed

That wasn't bad at all...

Thanks!

webchick’s picture

Oh wow, thanks! :D

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.