[FLOW3-general] Repository Query with isEmpty

Martin titusmailing at googlemail.com
Wed Sep 5 16:10:13 CEST 2012


Hey,

is this field empty?

In most cases NULL is the default value, try 
matching($query->equals('category', NULL))

May have a look at the table

HTH

Martin





On 09/05/2012 03:46 PM, flow3 at leakx.net wrote:
> Hello.
>
> That is my method:
>
> public function findAllWithoutCategory() {
> $query = $this->createQuery();
> return $query->matching($query->isEmpty('category'))
> ->setOrderings(array('name' => \TYPO3\FLOW3\Persistence\QueryInterface::
> ORDER_ASCENDING))
> ->execute();
> }
>
> I want to fetch all rows who has an empty entry in the column `category`.
>
> What is wrong ?
>


More information about the FLOW3-general mailing list