Error when trying to retrieve records in sorted order

REST API
1

I am trying to retrieve records from table in sorted order.
As per this documentation here:
https://wiki.dreamfactory.com/DreamFactory/Tutorials/Sorting_records
It should work and it is on dreamfactory instances with dreamfactory versions V 2.0.4 but same query is giving following error on V 2.1.2.

Failed to retrieve records from ‘users’.\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘first_name ASC’ in ‘order clause’ (SQL: select count(*) as aggregate from users order by first_name ASC asc)"

2

@mrvipinkashyap this bug is fixed in DreamFactory 2.2 .

3

Hi,

how can we fix this without upgrading. This is critical for one of the project we recently pushed live on a production, now we can upgrade the version. Please suggest.

Thanks

4

It seems that it was a mistake trying DF on MS SQL. After SORT we just realised the GROUP also does not function on MS SQL. There isnt much support on the forum for MS SQL either.

Thanks