Hi,
I have a sql lookUpService like below that works fine
@Override
public String getConfiguredSqlSelect() {
return "SELECT bestandsnaam, bestandsnaam " +
" FROM geluid " +
" <key>where bestandsnaam = :key</key> " +
" <text>where upper(bestandsnaam) LIKE CONCAT(UPPER(:text), '%')</text>";
}
but now I want to combine this with some fixed SQL like "where obsolete = 0". Whatever I do I always get an SQL error.
So can I combine a fixed sql part with a lookup service and if yes, how should I do it.
Regards Bertin