Hi, I'm looking for a way to find contstituents by their bank account. As off version 7.81 the account numbers are encrypted in the DB. Using the standard CustomWhereClause doesn't work because it queries the raw (encrypted) data. Is there a way to encrypt the plain text (account no) and pass...

Hello, I'd love your thoughts on how to approach the following issue: I have a monthly process that entails refreshing 15-20 queries with a specific date range (i.e. June 20-July 21) and then doing 5-6 exports based off of various of the queries. Currently, the process takes 4-6 hours due to the...