Add a scoring deduction for deceased records
I want to reduce the score when one record is deceased, but the other isn't. Right now the only way to avoid deceased records is by an exclusion query - but it takes too long to load such a large exclusion query.
Sandy Fiddis commented
I already tried that but my query is over 190,000 records. Ideally I would still want to be able to see whether a record matched a deceased record - if the last gift date was before the deceased date then there is a chance they really are a duplicate.
Hi Sandy, if you change that query to a Static query, does it move faster? (it does mean the query would need to be refreshed periodically, of course...)