Dropdown matching/sorting not working

Ignition
2

Q1. What flavour of SQL?
Q2. It looks like you are using a Named Query. Correct?
You could try,

SELECT columnName
FROM tableName
WHERE columnName LIKE CONCAT('%', :name, '%')

I suspect, however, that you are misusing the dropdown's search feature. The idea is that you generate the options list with a Query Binding which uses your Named Query. The dropdown's search feature just filters which dropdown options are displayed without the need to re-query the database. This should work for your requirements.

Please see Wiki - how to post code on this forum. Welcome to the forum!

1 Like