What is the best way to query data?

[Alejandro_Alaco]

The problem I found with named queries is that you can´t filter them with a multiselect of a parameter, have to do it with scripting query.

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.

But also named queries are quite useful to have all queries well organized, easy to edit and test and can recall them from any part of the app.