Oncondition Is Not Null

Yii 2.0 General Discussions
1

Hi,

I’m using [font=“Courier New”]onCondition([‘my_field’ => null])[/font] for retrieving entities which have a NULL-Value in my_field. Now I need to find a way to get the opposite done: [font=“Courier New”]my_field is not null[/font]. I tried [font=“Courier New”]onCondition([‘not like’, ‘my_field’, ‘null’])[/font] which is actually working but the syntax is kinda strange cause I have to define the NULL-Value as string.

Are there any other solutions?

2

Can you just write it as a string?




onCondition('my_field IS NOT NULL')