api feature request for usability: filter out deleted contacts unless is_deleted = 1 in parameters
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.