Hi All,
i’m using wappler 5.4.0, node js and MySQL. I have a paged query using Distinct, and configured to return nested query. Executing the query from the query builder returns 2 records, however, the API returns 4 records and ignores DISTINCT statement. Follows the query builder results:
Follows the API results:
Noted that the API is stating that there are total of 2 records, however, data contains 4 records (not 2).
Would you please advise with workaround if any till a fix is addressed?
Community Page
Last updated:
Last updated: