Where Clause inside Left Join

alf007

Hi!

I would like to know if the Editor can handle where clauses inside left joins?

Thanks.

allan

You should simply be able to use the joined fields like any other field:

Editor::inst( $db, 'users' )
    ->field(
        Field::inst( 'users.first_name' ),
        Field::inst( 'users.last_name' ),
        Field::inst( 'users.phone' ),
        Field::inst( 'users.site' )
            ->options( 'sites', 'id', 'name' )
            ->validator( 'Validate::dbValues' ),
        Field::inst( 'sites.name' )
    )
    ->leftJoin( 'sites', 'sites.id', '=', 'users.site' )
    ->where( 'sites.name', 'Edinburgh' )
    ->process($_POST)
    ->json();

Allan

alf007

Thanks Allan.

alf007

:)

mikesweb

how do you specify "in" i.e.,
->where( 'sites.name','Edinburgh','Glasgow')
or something like that?

allan

How to use operators such as IN is documented here.

Allan

mikesweb

I am asking how in the controller.cs file, not in php tho

allan

Sorry. You didn't mention that and you used PHP syntax. Here is the equivalent documentation for the .NET libraries.

Allan