Reference field autocomplete on an encrypted column

[Ruaa1]

Hello,

We have a table (table A) with a column that is a reference to another table (Table B). In the form of table A, we have the following settings for autocomplete on the reference field:

Reference field attributes:

birth_date=true,encode_utf8=false,last4ssn=true,ref_ac_columns=ssn;birth_date;last4ssn,ref_ac_columns_search=true,ref_auto_completer=AJAXTableCompleter

sys properties:

glide.ui.ref_ac.startswith --> false

user preference:

x_sduoo_credential_applicant.autocomplete.contains --> true

Encryption:

The ssn and last4ssn are added to Encrypted Field Configuration

Question:

_________

1. When we search by last4ssn or by ssn, no results are found.

2. When we search by date, it returns for the following: dd, mm, yyyy, mm-dd. But it will not return results for mm-dd-yyyy.

Best regards,

Ruaa