doctrine findby magic null value

php doctrine doctrine-1.2 findby
Sean picture Sean · Oct 6, 2010 · Viewed 27.5k times · Source

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

Daniel W. picture Daniel W. · Jan 31, 2013

Trying this gives me the error:

Catchable fatal error: Argument 1 passed to Doctrine\ORM\EntityRepository::findBy() must be an array, string given

So this works for me:

$repository->findBy(array('date_field' => null));

Related questions

How to query NOT NULL with Doctrine?

I have table Test: Test: id | name 1 | aaa 2 | 3 | ccc 4 | aaa 5 | 6 | ddd I want result where name is NOT NULL: aaa ccc aaa ddd How can i get with: Doctrine_Core::getTable('Test')->findBy('name', NOTNULL??) <-doesnt working …

Read More
how to convert Doctrine object into json

I am using Doctrine 1.2, how could I get the query object into json / array format? $user = Doctrine_Query::create() ->select('u.id, u.username, u.firstname, u.lastname') ->from('User u') ->orderby('u.id') …

Read More
Select One column Doctrine DQL

I need a simple column for a table. By example a table "project", with column id, name and year. If I do: $q = Doctrine_Query::create() ->select('a.pro_id') ->from('fndr_proyecto a') ->…

Read More