Paged query with DISTINCT and ORDER BY bug

Wappler 5.3.1
PG SQL 13
Node.JS 14

for the Wappler Paged Query step, if we have DISTINCT enabled and have sortable headers we get following error when we try to sort by any field from client side and request is sent with the sort param:
for SELECT DISTINCT, ORDER BY expressions must appear in select list

if we remove DISTINCT, sorting request from client side works as expected.

please fix.

Community Page
Last updated: