Oder by nulls last in doctrine
Jan 8, 2023 Symfony
$query =
$this->createQueryBuilder('categ')
->addSelect('CASE WHEN categ.listOrder IS NULL THEN 1 ELSE 0 END as HIDDEN list_order_null')
->addOrderBy('list_order_null','ASC') // always ASC -
>addOrderBy('categ.listOrder','ASC'); //DESC or ASC
symfony
doctrine
Categories
Recent posts
Oder by nulls last in doctrine [Symfony]
Switch between php7.4 and php 8.2 on macos [mac os]
Dump all variables present on a twig template [Symfony]
Dynamically update session duration [Symfony]