FileDropComboClass - Allow Sql LIKE Pattern Match as Alternative

[totalhip]

Curious if anyone has successfully extended the FileDropComboClass to allow sql LIKE matching as an alternative to the standard alphabetical search as entry occurs.

[MarkGoldberg]

Does this technique work for you ?
It’s not exactly a SQL Like, but you could easily weaken it to be one.

STContains - a sublime text style contains in Cw

SublimeText has this amazing navigation tool, part of which is based on a very powerful contains behavior. It takes each character you’ve typed into your filter, and it looks for those characters in the potential matches by looking for the characters in the same order, but they don’t have to be next to each other (and it’s case insensitive). So typing: abf.c will match things like ABFile.clw (bold letters show matches). To use it BIND('STContains' , STContains) BIND('mat:Descri…

[totalhip]

This could be very useful once I get the basics of the ABFileDropComboClass extended.

While I might be missing something, one of the things I’ve long found limiting about the shipping class is ALL records meeting the filter conditions are retrieved. However, on a table with thousands of records, even after a single letter is entered, the number of records to retrieve is likely significantly less.
Extending the class to get records only after X# keys have been entered is my first priority.

Once the above is added, I’m guessing it will not be much more work to include a property to set the search type (alpha, like, contains etc). My experience is with POSIX expressions in PostgreSQL and I am sure they will be sufficient for me.