Frontend UI SQL Server NULLS LAST

Support
,
#1

Hi all,

with the data store configured for SQL Server the query made by platform contain at the end of the order by clause the statement NULLS LAST that is not supported in SQL Server.

Is there a way to disable or change it?

I attach the log file of the error.error.log (42.5 KB)

Thanks to all

#2

This happens when there is sort parameter set.

 dataCollection = collection<AssetsAcceptance>(AssetsAcceptance.NAME, {
view: "assetsAcceptance-view",
filter: {conditions: [{property: 'signature', operator: "isNull", value: 'true'}]},
sort: "-updateTs",
loadImmediately: false

});