Submitted by WayneK on 2022/07/13 14:09

Find & Filter search results included partial-word matches when "Whole Word only" was specified

Find & Filter search settings = <Entire File/Show in Live Search/Selected Column/Exact String/Whole Word only>

Search = LED

Search results included = pulLED, faiLED (etc)

Changing search to "LED" still included spurious results (though maybe not as many).

Wayne

Win 10 120Pre21

Comments

Was hoping it would clear up with updates but it's still not working for me. Searching for "Proj" returns "Projects" even though whole word option is selected.
What do I need to upload? I don't know what you mean by "sample app". Do you mean a sample file with a search set up showing the problem?

Wayne
Win 10, 120, Pre24

Wayne

Naturally, it works fine in the sample file. 

My system is really messed up right now with many cases of buffering, locking up, and other misbehaviors.  I tried repairing the database but it ran for 40 minutes with no resolution and I had to kill the process.  Tried again later and this time it ran for an hour without completion.

File is appx 180,000 items and 95 mb.

Wayne

It could be a problematic grid that locks up the repair process, I've seen this before, what you can do is mask the content (Tools > Database > Repair > More > Mask), compact  and zip. Send it to me

(of course, do this on a copy of the file)

Pierre_Admin

Indeed, the purpose is to find what is preventing the repair process from completing (and this most likely has nothing to do with the actual data, more with fields, grids, etc) 

Tools > Database > Delete all items

 

Bug reports