[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