Pulling filtered table component results into a SQL table

Queries and Resources
1

Greetings, I love the filter feature available for tables...it saves tons of coding work for me, but I'd like to add work after the filter is applied. To do this, I am hoping to full the table contents into a SQL table in the Retool Database.

I would love to be able to do something like an "INSERT INTO" statement to pull data out of a filtered table component so I can have some additional SQL work take place in the back end, but I haven't been able to find any way to do this. I've tried using the "getDisplayedData" function, but I'm guessing there are some formatting issues between the two.

Has anyone done anything like this before?

2

Hi @dndgeek2005,

It seems like getDisplayedData would work well for this use case. If the formatting needs to be changed, you could use a JS query to transform it.

Happy to take a look at any screenshots or examples you have where it isn't working!