Hi all, I'm getting unexpected errors with a query that I'm trying to set-up (Query JSON with SQL). This is working as expected: select * from {{formatDataAsArray(import_all_results.data)}} limit 10 The following doesn't work: select * from {{formatDataAsArray(import_all_results.data)}} limit…

This led me in the right direction. For my particular use case we were not able to user server-side pagination since our query included several filters and CTEs. I ended up paginating the resulting dataset through a transformer: const data = {{ myquery.data }} // formatted as an array const pageSi…

Limit clause throwing unexpected errors via Query JSON with SQL

💬 Queries and Resources

agaitan026 October 23, 2023, 6:53pm 6

ey can you help me? im having i think the same issue as yours Pagination Offset in Query JSON with SQL - #7 by agaitan026 in this post i got the details

Topic		Replies	Views
Pagination Offset in Query JSON with SQL 💬 App Building	6	2342	October 27, 2023
Dynamic LIMIT value in SQL query 💬 App Building	6	705	July 1, 2024
Getting parse error in server side pagination 💬 Queries and Resources	2	1331	August 2, 2023
How to use "Selected Page" for Server Side Pagination 💬 Queries and Resources	16	3802	February 19, 2024
Sql with a table with 100000 records slow query 💬 Queries and Resources	24	3122	December 4, 2023

Limit clause throwing unexpected errors via Query JSON with SQL

Related topics