How to add clause "where" with Velocity property to SQL query in "Database multi-select" field?

Konstantin_rxmp2t

Hello.

I have a big table with 30k+ rows. I need to create a "Database multi-select" field with restrictions in query.
Now it works as follows: it receives all data from the database (30k+ rows), prints them in the form field and after that it can filter them according to the entered text. This process takes a lot of time, and all users think that the window freezes.

How can I create a filter in an SQL query using Velocity properties or something like that? Because the filter after receiving all data is not suitable for me.

Thanks.

Alex Medved _ConfiForms_

For the database fields to work we need to load all the data for the field

Obviously, having something with 30+ in a dropdown is not something we ever expected for the field to have.

We have a "Dynamic dropdown" field that supports "proxy" mode and can help you with dynamically created lookups against your database.

Though, it does not support multi-values as of now

Alex