V3.9.9 - DISTINCT doesn't work when used in a Paged Records Query Type

Wappler Version : 3.9.9
Operating System : MacOS
Server Model: ASP.NET
Database Type: MSSQL
Hosting Type: IIS

Expected behavior

The Server Action is expected to Fetch DISTINCT Paged Records from the database tables.

Actual behavior

The Server Action fails when DISTINCT is used in a Paged Records Query Type. The query fails with the MSSQL error (in the developers tools) - Incorrect Syntax near the word DISTINCT.

How to reproduce

  1. Create a Paged Records Server Action
  2. Add Select DISTINCT option to the Query
  3. Server Action fails when the Paged Query is run
Community Page
Last updated: