we update Mashzone from 9.12 to 10.3 and now we search how to build entire SQL query for JDBC.
I explain in my query if a user choose in input list All, we need a condition like this
APP LIKE ‘%’ OR APP IS NULL
If he choose value
APP LIKE ‘VALUE’
if he choose multi
APP IN (‘V1’, ‘V2’)
In 9.12 we can do it with parameter [PARAM] but now with :PARAM is impossible
Can you help us ?