Interval field on the Separate PM Action screen only allows number values. Therefore, when sorting, it is expected to follow numeric sorting and not alphabetical sorting. “Interval" accepts a numeric value and therefore should be sorted numerically by clicking on the column header - as per standard functionality. It is not acceptable that the application behaves in different ways at different places.
What should be a one-click sorting operation has now become a multi-step procedure involving the user to be trained in SQL?
You can simply solve this with a slight change to the SQL query on the Advanced Search. Please follow the steps below;
1. Go to separate PM actions window.
2. Search, go to Advanced search.
3. Enter object site 101 and Interval-Sort: Ascending
4. Go to the SQL tab in the “Search” dialog and set the SQL order by expression to, “TO_NUMBER(INTERVAL)”.
5. Press Search. Now the interval should be sorted as expected.
Even though the “Interval” field accepts numeric values, it is not that simple to allow to be sorted numerically. The reason for that is; the “Interval” field is not a “Number” field, instead it is a “String” field in the database side. Therefore, it is sorted in alphanumeric order.
1. Go to separate PM actions window.
2. Search, go to Advanced search.
3. Enter object site 101 and Interval-Sort: Ascending
4. Go to the SQL tab in the “Search” dialog and set the SQL order by expression to, “TO_NUMBER(INTERVAL)”.
5. Press Search. Now the interval should be sorted as expected.
Even though the “Interval” field accepts numeric values, it is not that simple to allow to be sorted numerically. The reason for that is; the “Interval” field is not a “Number” field, instead it is a “String” field in the database side. Therefore, it is sorted in alphanumeric order.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.