Server side sort using codeless and event handler

[Thomas_Wirth]

Hi,
I am trying to add the sortBy parameter into a query in a beforeFind event handler as mentioned here:

Data Table column width

Hi @viktor.liablin , For the ticket: What is required urgently as well is to have a default sorting for columns (at least one). Or is this already possible somehow? Regards,

See the example attached. (i have tried to add the order by clause with text, raw text,
as ‘name asc’ and as ‘order by name asc’.
The code is deployed but i do not see any change in how the records are returned (using REST Console and a data table in the UI builder).
I have also tried to return the Request Query block in the API Event before find block, but that’s not it.

Obviously I am using the wrong syntax or property name.
Thanks for any hints you can provide.

Best regards, Thomas

[mark-piller]

Hi Thomas,

Yes, this is not very straight-forward, we should do a better job documenting the request structure. Here’s the codeless logic that will do the trick:

The key is to update the queryOptions property of Request Query and make sure the provided value is a list.

Regards,
Mark