AnsweredAssumed Answered

Find not working, index is fine

Question asked by CarlSchwarz on Nov 13, 2016
Latest reply on Nov 13, 2016 by philmodjunk

I'm doing a find on a text field in a rather large table for 9655.  Instead of returning 9655 it is returning 7840 (or something like that, can't remember exactly).  I've tried rebuilding the index and it didn't help.

Any ideas what is going on here?

 

Exactly the same happens if I do a find on ==9655  and also it's ID in the id field is 264 and finding on 264 also only returns the 7840 records...

Outcomes