How to use IS NOT NULL in Associative Array

Question

I am new in Symfony framework And I want to use Query basis on Condition

which is using associative array and I want to use IS NOT NULL But it is not

working.

$repository = $this->getDoctrine()->getRepository('AppBundle:Order');
$order = $repository->findBy(array('status' => $last_status,'new_coloumn_id'=>"IS NOT NULL"));

How to use IS NOT NULL in array.

Mert Simsek · Accepted Answer · 2017-10-31 08:55:19Z

4

You should add custom function into your Order Repository file(class). Example;

public function getOrderStatus($last_status = NULL){
    $query = $this->createQueryBuilder('order')
        ->where('order.new_column_id IS NOT NULL')
        ->andWhere('status = :status')
        ->setParameter('status', $last_status);

    return $query->getQuery()->getResult();
}

And you can use it;

$order = $this->getDoctrine()->getRepository('AppBundle:Order')->getOrderStatus($last_status)

answered Oct 31, 2017 at 8:55

Mert Simsek

1,56011 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Juan I. Morales Pestana · Accepted Answer · 2017-11-01 12:31:21Z

0

Try this in your repository class:

public function findOrder($last_status){
        $qb = $this->createQueryBuilder('order');

        return $qb->where($qb->expr()->isNotNull('order.new_column_id'))
            ->andWhere($qb->expr()->eq('order.status',':last_status'))
            ->setParameter('last_status',$last_status)
            ->getQuery()
            ->getOneOrNullResult();//getArrayResult,getResult()

    }

hope it helps...

answered Nov 1, 2017 at 12:31

Juan I. Morales Pestana

1,1671 gold badge10 silver badges43 bronze badges

Collectives™ on Stack Overflow

How to use IS NOT NULL in Associative Array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related