Citizen Posts - Windmill

Citizen

•Created by Citizen on 5/20/2025 in #help

MySQL script - Argument support list

Hello, I have a MySQL script, and I wish to used named arguments :

-- database f/main/my_database
-- :ids (string[]) <-- Doesn't work, same for (int[])
-- :begin_date (string)
-- :end_date (string)

select *
from my_table t
where t.id in (:ids)
  and t.date between :begin_date and :end_date

-- database f/main/my_database
-- :ids (string[]) <-- Doesn't work, same for (int[])
-- :begin_date (string)
-- :end_date (string)

select *
from my_table t
where t.id in (:ids)
  and t.date between :begin_date and :end_date

My issue is I don't know how to name my type in order to support arrays (or list), Can you help me ? I can't find the official documentation in this page https://www.windmill.dev/docs/getting_started/scripts_quickstart/sql#mysql-1 Thank you for your time !

26 replies