Trembowiecki
Active Member
Hi,
the thing is - I want to sort alphanumeric strings in list view , but since my element is varchar, Fabrik doesn't orders numbers correctly. So instead of test1, test2, test3, test10, I get test1, test10, test2, test3. There are a few ways of correcting it in pure MySQL (ie. with a help of CAST), but how can I play with this more advanced ordering in case of Fabrik lists? Where can I determine such ordering?
Cheers,
Olek
the thing is - I want to sort alphanumeric strings in list view , but since my element is varchar, Fabrik doesn't orders numbers correctly. So instead of test1, test2, test3, test10, I get test1, test10, test2, test3. There are a few ways of correcting it in pure MySQL (ie. with a help of CAST), but how can I play with this more advanced ordering in case of Fabrik lists? Where can I determine such ordering?
Cheers,
Olek