No option for a data source in Select Component

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 {{}} 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 {{}} directly in the select config