Hi,
the search function via the plugin does a nice job. But there could be a small, but important improvement.
As I see so far, the search can be used with "&" and "%" as SQL-statements (maybe more).
1.) In our case we have documents which are named "1&1 Document 123" (e.g.), the part "1&1" is a company name. So we will not be able to search for it.
2.) It's not so easy to tell our clients to work with the SQL-statement "%" (e.g.) as a wildcard.
It would be very nice if you could integrate an option within the search plugin, that solves that problem:
Either using the already existing method, or:
Every single search phrase will automatically be extended by a "%" and be connected with an "and" statement".
So if someone's search looks like:
"1&1 Invoice 62.20" the search string should (could) like:
select... from... where... Fieldname1 = "'1&1'%" and Fieldname2 = "Invoice%" and Fieldname3 = "62.20%" – (just to give you an example...)
That would be very convenient for any user with no SQL-knowledge.
Do you think that could be done without big efforts? We would really need this pretty much on time...
Thanks for your always perfect support!
Best
Stefan