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 that in the customwhereclause ?
Or another filter object where I can give the account no in plain text as a parameter that returns a constituent collection ?

Eric

Eric, 

Ran into the same problem. We match on Cfin2 bank Route & bank Account. The api returns the full Route and a mask acct, so changed to match on the last 4 bank account.

sWhereBranch = "Constituent_Bank.BRANCH_ID = " & lBankId
    oFins.Init moSc, , tvf_Fin2_CustomWhereClause, sWhereBranch, True

For Each oFin In oFins
        sFin2AccountLast4 = Right(oFin.Fields(FINANCIAL2_fld_ACCOUNT_NO), 4)
        If sFin2AccountLast4 = sAccountLast4 Then...

Hope that helps, 

Kevin Strange

PCUSA