Mjoin ->where always null

json81

Hi!
I have a working Mjoin. I would like to remove records with null-values. I have set "->where" under "->options" but no matter how I write, SQL will end up with "IS null".

Example:

        ->join(
                    Mjoin::inst( 'customer' )
                    ->link( 'user.id_user', 'user_customer.id_user' )
                    ->link( 'customer.id_customer', 'user_customer.id_customer' )
                    ->order( 'company asc' )
                    ->fields(
                        Field::inst( 'id_customer' )
                            ->validator( Validate::required() )
                            ->options( Options::inst()
                                ->table( 'customer' )
                                ->value( 'id_customer' )
                                ->label( 'company' )
                                ->where( 'company',null,'!=' )
                            ),
                        Field::inst( 'company' )
                        )
                   )

**Debug: **

{"query":"SELECT DISTINCT id_customer as 'id_customer', company as 'company' FROM customer WHERE company IS NULL ","bindings":[]}

I guess I am doing something wrong. Any help would be much appreciated.

/Anders

json81

I am using Editor-1.9.2 and PHP server side.

rf1234

I found this comment in my code:
//where clause MUST be a closure function in Options!!!

You'll probably also find it in the docs somewhere?!

->options( Options::inst()
    ->table( 'customer' )
    ->value( 'id_customer' )
    ->label( 'company' )
    //where clause MUST be a closure function in Options!!!
    ->where( function($q) {
        $q ->where( 'company',null,'!=' );
    } )
),

json81

Hi!
Thank you! I have tried it and it works.

Best Regards
Anders Jansson

rf1234

You are welcome, Anders. You'll probably use "Options" more frequently. This post might be useful for you going forward.
https://datatables.net/forums/discussion/comment/116150/#Comment_116150

Roland