We have found that sorting a list with values 'filters' out certain rows, which of course is not expected behaviour.
List before sortrecordlist:
01-07-2020 B 121489 M-Tu-W-Th01-07-2020 L 103935 Weekday01-07-2020 R 115751 Weekday01-07-2020 S 106226 Weekday01-07-2020 Z 119220 Weekday02-07-2020 B 121489 M-Tu-W-Th
SortRecordList on Date and Code (first and third column)
Result:
01-07-2020 L 103935 Weekday01-07-2020 R 115751 Weekday01-07-2020 S 106226 Weekday01-07-2020 Z 119220 Weekday
So the text-values with a '-' in it are 'filtered' out ;-)
What can we do to prevent this?
kind regards,
Paul / CoolProfs
Hi Paul,
i tried to replicate this last night with some values containing a '-' and couldn't. (see attached oml)
Can you share a demo oml where this is happening, to see what exactly you are doing different from me ?
Dorine
Your demo is OK, as are other examples...
Switched over to platform listsort and distinctlist actions. These work as expected without the strange problem mentioned above.