Is there a way to change how the numerical order in some fields works? For example when I order the below column, ifs orders it by first digit, then second. How can i get this to be ordered 1 - 26 and not as it below?
Numerical Order
Userlevel 3
+8
Is there a way to change how the numerical order in some fields works? For example when I order the below column, ifs orders it by first digit, then second. How can i get this to be ordered 1 - 26 and not as it below?
Hi,
If you check the database view of this table you will see that line no is defined as a VARCHAR2 column.
So, you can’t order it by Line no since it isn’t a Number field. But I can suggest you a workaround. Create a custom field by converting the VARCHAR2 to Number field. Then you will be able to sort the table view by newly created line no.
BR,
Kavindu
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.