Multiple Sorting Problem

Classic Servoy
1

Hi,

I’m sorting my records by a date field asc first and then by the ID (integer).

It seems there is a problem with this (pls see the pic)

The records are sorted by date correctly but ID’s are not sorted. The first ID in the same date is pushed after the last entry in the same date which is not right.

Is this a bug or I missed something

Thanks

2

Hi,

Is it possible that it is a datetime field? You do have it set so that only the date part is showing but normally SQL databases are in fact datetime fields. Thus the time would also involved in the sorting on the day before the secondary sort would be involved.

John

3

Hi John,

Your assumption was right. Thanks for your direction. Now it’s fine

Thanks
Ahmad