Wappler Version : 3.9.9
Operating System : MacOS
Server Model: ASP.NET
Database Type: MSSQL
Hosting Type: IIS
The Server Action is expected to
Fetch DISTINCT Paged Records from the database tables.
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
- Create a Paged Records Server Action
Select DISTINCToption to the Query
- Server Action fails when the Paged Query is run