Filtering table from multiselection dropdown

You cannot pass lists into single JDBC parameters.

If you script your query with runPrepQuery instead of using a named query, you can dynamically generate question mark placeholders for all of the list elements, then pass the correct length argument list.

1 Like