Goal: I want to create an App with some visualizations and use some filters (Date, dropdown) on the top of my page to filter the dashboard using those filters.
Steps:
I have created an App and added the filter components in it.
Now I am unable to figure out how to connect these filters to the data and use them to filter the data on the App.
You can add some of these conditions to your queries in order to filter the results based on your selected options:
First one is for text inputs, second one is for multiselects and third one is for normal selects. Don't forget to change "title" and the components names to match your app.
You should be filtering query4 using that multiselect code, not query6.
query6 should be a simple query with a list of statuses to populate the multiselect, for instance:
The source of your multiselect shouldn't be the same query, it should be a list of statuses, either from database or manually input. Maybe for now, switch the mode to manual and insert the status manually.
Can you show what the error is on the query?
Hi @GuilhermeSilva , I have given different query as data source to multiselect which only shows status column from the table.
Now I am running the query and it is showing below error:
Can we please connect over zoom call or something? I am doing a POC on Retool to check if it will be a good fit for our company or not. I have few doubts in REST API, Workflows and data filters.
Let me know if its possible or if you can connect me with some technical person.
That was an example. Replace [123,224] with your array (multiselect1.value) and make sure you haven't disabled prepared statements on your Resource's configuration:
Snowflake has a different structure and syntax, can you try this?
If it doesn't work, it's probably best to follow Paulo's advice and join office hours next Tuesday.
SELECT * FROM SUPPLY_CHAIN.SUPPLY_CHAIN_DATA
WHERE ({{multiselect1.value.length == 0}}
OR ARRAY_CONTAINS(ORDER_STATUS::variant, SPLIT({{multiselect1.value.join("---")}},'---')))
