Paged Query Sort Param throwing Error when Empty

sid · October 28, 2021, 4:32pm

Wappler Version : 4.1.3
Operating System : W10
Server Model: ASP .NET
Database Type: MSSQL

When calling a server action which has a paged query using server connect, initially I should not have to send a sort or direction param.

If the sort param is empty, the step is throwing a 500 error:

Message: "The ORDER BY position number 0 is out of range of the number of items in the select list."

Create a regular paged query in a server action and try calling it using a server connect without setting any sort or direction params.

Teodor · October 27, 2021, 11:59am

patrick · October 28, 2021, 4:32pm

Test this update:

sid · October 27, 2021, 2:47pm

That works. Thanks.

Teodor · October 28, 2021, 4:32pm

Teodor · October 28, 2021, 4:32pm

This has been fixed in Wappler 4.2.1

Teodor · October 28, 2021, 4:32pm

Teodor · October 30, 2021, 3:00pm

This topic was automatically closed after 46 hours. New replies are no longer allowed.