CakePHP: Find where the field is nonzero

Question

I need to select all rows where User.site_url is not null. It is simple enough to do this in a regular MySQL query, but how is this done in CakePHP?

The manual mentions the following:

array ("not" => array ( "Post.title" => null ) ) 

I tried the following, but it still returns everything

 $this->User->find('all', array('conditions' => array('not' => array('User.site_url')))); 

Answer 1

I think this is what you mean:

 $this->User->find('all', array( 'conditions' => array('not' => array('User.site_url' => null)) )); 

Answer 2

You just have zero

 $this->User->find('all', array('conditions' => array('not' => array('User.site_url'=>null)))); 

Answer 3

In Cake, the WHERE clause is constructed from the "conditions" element by combining keys and values. This means that you can skip providing keys if you want. For example:.

 array('conditions' => array('User.id'=>1)) 

completely equivalent

 array('conditions' => array('User.id = 1')) 

Essentially, you can only solve your problem with this:

 $this->User->find('all', array('conditions' => array('User.site_url IS NOT NULL'))); 

Answer 4

You can also try this,

 $this->User->find('all', array('conditions' => array('User.site_url <>' => null)); 

This works great for me.

Answer 5

This work great for me:

 $this->User->find('all', array('conditions' => array('User.site_url !=' => null)); 

Answer 6

Try '' instead of null :

 $this->User->find('all', array('conditions' => array('User.site_url <>' => '')); 

Answer 7

For a simple query:

 $this->User->find('all', array( 'conditions' => array( 'User.site_url IS NOT NULL' )); 

For cakephp 3.X

  $table = TableRegistry::get('Users'); $assessmentComments = $table ->find() ->where(function (QueryExpression $exp, Query $q) { return $exp->isNotNull('site_url'); }) ->all(); 

Answer 8

this area is correct! (Ctlockey)

 $this->User->find('all', array('conditions' => array('not' => array('User.site_url' =>null)))); 

However, I have used conflicting results with different versions of MySql and MariaDb. I find that a little straightforward SQL is not so bad as to ensure return integrity.

So I did the following:

 $Obj->find()->where(['field_a IS NULL', 'field_b IS NOT NULL'])->all(); 

Answer 9

Works for me

 $this->set('inventory_masters',$this->InventoryMaster->find('all',array('order'=>$orderfinal,'conditions' => array('InventoryMaster.id' => $checkboxid,'not' => array('InventoryMaster.error'=>null)))));