We enabled platform encryption and encrypted two standard fields, field1 and field2 for an object.
We were querying the data from that object and using encrypted field for ordering the data by field1 and field 2 to display results in VF pages and Portals. Not just querying, but used in other reports as well.
Encrypted fields cannot be used in where clauses of query of order by in soql and it throws an error on pages.
How can we allow access to the data in these situations?