Count Records INCLUDING Marked For Deletion

[blueprint]

I want to count the number of records created on a certain date, but this number MUST include those marked for deletion

$count = $this->getEntityManager()->getRepository($entityType)->where([
    'createdAt*' => date("Y-m-d %:%:%")
])->count();

The above code only counts the non-deleted ones.

How can I take into account those records which have been deleted?

[item]

Hello,
by PDO
a sample.. you need use select count

$pdo = $this->getEntityManager()->getPDO();
        $sql = "DELETE FROM scheduled_job_log_record WHERE status='Success';DELETE FROM job WHERE status='Success'";
        $sth = $pdo->prepare($sql);
        $sth->execute(); 

[blueprint]

item nice one, thank you - I’ll try this tomorrow!

[yuri]

This should work out:

$count = $entityManager->where($clause)->count(['withDeleted' => true]); 

[blueprint]

This should work out:

$count = $entityManager->where($clause)->count(['withDeleted' => true]); 

yuri thank you - this looks like a nicer solution but its useful to know about both methods.