Hi,

I have activated deterministic encryption and am testing the "filtering" capabilities.  This is in a brand new dev org, so no previous encryption was enabled.

I know only = and != (equals and not equals) will work, and that text filtering is case sensitive, but it seems that it DOES NOT work with existing values.  For example, I have enabled deterministic encryption on the Lead Email field.  If I try and do an export, I can now see the "email" as a field to base my condition on (that is not the case when using probabilistic encryption), but when I use = email@email.com it does not find the record that I know exists.  If I then edit/save that record then it finds it.

It seems to ONLY work for new records inserted, or existing records saved since the encryption was enabled.

Is there a step I am missing to get it to work for all existing values where the records has not been edited?  If not, this seems like a huge flaw.

NOTE:  I have tested with Email, Name and Phone fields and NONE of them work for finding existing values.

Thanks, Laurie