The whole point of encrypting the data at rest is to make it unreadable at the database level, which has some usability consequences:.

Encrypted extrinsic Attributes:

1. Cannot be exposed through systems such as OData that pull directly from the database

2. Can only Cannot be searched using exact, case-sensitive string matchingagainst