datatables editor select from a table exclude is null

marcdekam

Hi,
I want to include a dropdownlist. in this list I want to include values from a table that match a sql expression 'where field IS NULL'
how do I do this.
this is what I have now and is not giving any resuls in the dropdown.
```
Field::inst( 'ea.id' )
->options( Options::inst()
->table( 'reportengine_cfg'.$_SESSION['dblink'].' e' )
->value( 'e.id' )
->label( 'name' )
->where( function ($q) {
$q->where( 'e.parent_id', 'is null' );}
)
),
````
regards Marc

rf1234

take a look at this please https://editor.datatables.net/manual/php/conditions

Search for "Null values" on that page