GitLab

The title says it all... when pulling a contact by email, I should only get undeleted contacts. This is painful when something works fine on dev then you move it to stage, with a much bigger dataset that includes billions of deleted contacts, and everything breaks.

"where is_deleted=0" should be a part of all api calls unless you specifically indicate that you want deleted stuff.

$result = civicrm_api3('Email', 'get', [
  'sequential' => 1,
  'email' => "someuser@somedomain.org",
  'api.Contact.get' => [],
]);

returns all contacts with that email attached. By default it should only include contacts that aren't deleted.

Just a suggestion! No one is interested in deleted contacts unless they're removing them permanently or undeleting them.