Modify getAll to exclude deleted data -> yuanzhe