Using Query Builder with an uploaded csv

Queries and Resources
1

Hi! I am new to retool and trying to build something simple using an uploaded csv. When I try to apply the Query Builder output to this, I cannot seem to get it to work.

In the query, I selected Query JSON using CSV
And I tried to do:
select * from {{table1.data}} {{queryBuild1.asSql}}

suspecting a type issue somewhere but not familiar enough with the tool to know how to solve it.

2

Hi! Welcome to the Retool community. In this instance, the issue is more with using the queryBuilder component in a 'Query JSON with SQL' query.

The queryBuilder component requires the resource to have "Disable converting queries to prepared statements" toggled on (which is not an option for this query type).

You can use the table's built-in filter or if you want to use the query builder component you will need to somehow filter these results another way.

You add a transformer to the Query JSON with SQL query but without the queryBuilder (select * from {{table1.data}}) and add a Transformer to that query that parses out those values. Here is an example"

let rules = {{queryBuilder1.value.rules}}
let filteredData;

for (let rule of rules) {
if (rule.operator == "like") {
filteredData = formatDataAsArray({{table2.data}}).filter(r => r[rule.field] == rule.value)
}
}

return filteredData

1780×1416 183 KB

3

Thank you @retool_team - if I use the table's built in filter, how do I get a list of filtered values from that table? I tried this as well and noticed that I was still getting the full table of values when I try to use the filtered data elsewhere.

4

If you reference the table's displayedData that will reference the filtered data.