Currently, when using "one of" criteria and then searching from a list of table entries, you cannot search by a special character. I have specifically tested this with Fund ID for the characters !, *, #, @, &.

In our shop, and I'm sure we're not alone, we use a special character to differentiate between certain types of funds in the Fund ID. We use # to denote an Endowed fund. Up to now, we were able to search in the query criteria fields for *# (wildcard telling you to find # somewhere in the code name) and it would bring up every endowed fund (we have around 100) making it very easy to select all Endowed funds.

Webview query cannot do this and this is a huge problem for usability. It means somethign that takes us about 30 seconds to accomplish in database view query takes 10+ minutes to accomplish in webview query. This is aside from other usability issues with the UX for the "one of" criteria and how it allows you to view and select tables entries during query set up. (I'll be creating a separate idea for this one.)

But losing the ability to use our current coding intelligently in RE is crippling to our organization and so I strongly urge Blackbaud to make all characters searchable in webview query.