Make the selections in a Select Component come from a query.
When I create a new Select Component there is no selection between Manual and Mapped data source. I tried adding a {{query}} directly to Values but it didn't work.
Thank you for your time.
I solved it by running the query in SQL Mode with:
SELECT column_name
FROM table_name
and then using a transformer to turn the result, which was an object, into an array with:
return data.column_name
Then i just added {{query.data}} in the Values section of the select component and it worked fine.
Does anyone know if there is a way to get an array directly from SQL so as not to use the tranformer?
Hi @Last_First,
As long as you wrap your input in double curlies {{}}, you can use Javascript to key into the data that you want to use
You could keep the SQL query as an object & put {{queryName.data.column_name}} directly in the select config