Hi,
I am trying to use a collection of strings in an in clause. The collection
contains the following values "STCTEST" and "ABCD". I want the generated
sql to look like IN ('STCTEST', 'ABCD*) but JOOQ generates IN ('[STCTEST,
ABCD]'). Not sure what I am missing;
The code used is as follows:
private void addToSql(SimpleSelectConditionStep<Record> sql,
String columnName, Set<String> values, AtomicInteger index) {
if (values != null && values.size() > 0) {
sql.and(Factory.fieldByName(String.class, columnName).in(values));
sql.bind(index.getAndIncrement(), values);
}
}
/Pelle
