I have looked to see if this is already possible in the module, but can't see anything, and I also can't find any previous requests for it...

Is it possible to nominate a second (or even third!) column for sorting on - so if the default/main column has a number of identical values, it reverts to the second column to determine the sort?

In the way I use it (player statistics in a sports team), players frequently have the same average score (which is sorted), and therefore we rely on a second statistic of theirs to determine who is higher. How does tablemanager resolve this currently?

Comments

pobster’s picture

This is one of the main reasons I'm rewriting Tablemanager as user specified flexibility such as this is almost impossible to facilitate. Tablemanager currently sorts on the field you give it, plus the field next to it (to the right) - I've a weird memory of having a third column as well, but without checking I couldn't tell you whether I followed through with it or not. For the time being, you'll have to put the second statistic next to the score - then it should pick it up by itself.

...Unfortunately I haven't written the code for editing table columns so you'll have to either remake the table, else move it manually, else... I am pretty imminently going to push out version 2.x which is a huge leap forward for Tablemanager - maybe wait for that? Although my spare time is hugely limited at the moment...

Thanks,

Pobster

TimmyRaa’s picture

Cool, thanks - it's no big issue at the moment, but would be a nice to have down the line sometime. I'll bear in mind the options I have at the moment, but I'll likely wait. :)

Keep up the good work!

pobster’s picture

Status: Active » Closed (fixed)

Thanks! I'll close this issue for the time being as I said, this is almost impossible for the 6.x-1.x branch but the 2.x branch will easily be able to cope with managed 'ORDER BY...' statements.

Pobster