Re: Search for Constituents by bank account

Kevin Strange — Fri, 09 Jan 2009 18:48:57 GMT

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

Search for Constituents by bank account

Eric Bracke — Sun, 19 Oct 2008 16:58:38 GMT

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

VBA/API

Re: Search for Constituents by bank account

Search for Constituents by bank account