With the MSSQL adapter, sorting tables in dataManagers listView fails, due to an error in the generated SQL Query.
The display of a data page in listView consists out of two queries. On for the data and one for the number of found records.
The query for the number of found records is wrong:
the order by attribute is not allowed in MSSQL.
the fix/workaround is quite easy. In 'PresideObjectService.selectData()' (line 211), the argument 'recordCountOnly' can be evaluated:
This change fixes the sorting issue but is also a perfomance improvement for all places where the recordcount is shown. Not only for MSSQL, also for all other databases.