ONEFORALL - Group sorting bug

[DarkViper]

If it is certain that 'f.value' contains a number (integer), it is easier to evaluate this value in the sorting as a number.
This can be achieved with the SQL function CAST(expression AS datatype)'.

Code Select Expand


  .'ORDER BY CAST(`f`.`value` AS UNSIGNED) '.$group_order.', `i`.`position` '.$position_order.$limit_sql;

see:
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html#function_cast (function cast and description of types in function convert)

[CodeALot]

You're the best. That solved it. MANY thanks!

[dbs]

Hi, try this. Find in view_overview.php the block.

Code Select Expand

// If a group field is defined order by group and position

Last line of this block is

Code Select Expand

          .'ORDER BY `f`.`value` '.$group_order.', `i`.`position` '.$position_order.$limit_sql;

Change it to

Code Select Expand

          .'ORDER BY LENGTH(`f`.`value`), `f`.`value` '.$group_order.', `i`.`position` '.$position_order.$limit_sql;

Only this is added: LENGTH(`f`.`value`),
Hope it helps.

[CodeALot]

If you use field type GROUP in OneForAll and SHOW GROUP HEADERS on, SORT BY GROUP on, the sorting goes wrong once you use more than 10 groups.
Sorting is done like:

1
10
11
2
3
4
5 --- etc.

Does anyone have a brilliant idea how to solve this?