I'd like to use the toolbar filter button in the new table component with server-side pagination. Hence I have to integrate the filter config in filterStack into my PostgreSQL query myself, right? This must have been done many times already. I don't want to re-invent the wheel, but I couldn't find …

Hello :wave: I came across this problem, and then your question, and then the generally missing solution. I'm sure you've resolved this now, but for anyone new coming to this problem, here is how I've handled it, in case it saves anyone else some time. This is for mapping Retool's table filters on…

JS code to produce SQL WHERE clause from filterStack

💬 App Building

Paulo February 13, 2024, 11:46pm 2

Hi @cstork, unfortunately there is not a built in way to do this. @Tess' approach is currently the only way to achieve it.
This may also be helpful: Showing data when filter is not in use.

Topic		Replies	Views
Server-Side Pagination With PostgreSQL 🤝 Community Show & Tell sql , postgres , table , pagination , preloaded-javascript	2	1466	March 12, 2024
Filtering table in retools frontend using search bar 💬 Queries and Resources javascript , sql , table	11	3985	May 6, 2024
Table's client side filtering outside of table 💬 Queries and Resources sql , table	6	4518	August 2, 2023
Filtering table in JS (caching settings, how to trigger transformer, and use values in JS code query) 💬 App Building javascript , table	5	5902	July 27, 2023
How can I access the data in a table that has filters applied? 💬 Feature Requests table , component	17	3434	October 9, 2024

JS code to produce SQL WHERE clause from filterStack

Related topics