doctrine findby magic null value

Question

Hey fellow programmers,

I'm wondering if there is anyway to use doctrine's magic method to look for null values. For instance:

Doctrine::getTable('myClass')->findByDeletedAt(null);

Essentially, i want to return all records that are not deleted. I've tried the above, but it doesn't seem to work.

Any ideas?

Answer 1

Actually, i think i was trying to be too fancy. It can be done like this:

Doctrine::getTable('myClass')->findBy('deleted_at',null);