in my workflow I want to filter the list extracted through a sql.
I have set a first question where I input the value of the search (% filter%)
in the second question i sets a type selected from sql
in the query i have set
"select pratica_numero, client_name from pratiche
where cast(pratica_numero as varchar(5)) like %filtro% order by pratica_numero desc"
the column pratica_numero is a integer value
now in the first question i put the value es 403%, in the next question the result of picklist is empty