where in options seam not working

magnus@greatlord.com

Hi
I got a problem no optiopns are listed for kchcr.cylinder_id
->where( 'coworing_hotel_place_id','kchr.coworing_hotel_place_id ') seam not working
how to solv it ???

Editor::inst( $db, $wpdb->prefix . 'kolrooms_coworing_hotel_costumers_rooms kchcr', 'id' )
->fields(
Field::inst( 'kchcr.rooms_id' )
->validator( Validate::notEmpty() ),

    Field::inst( 'kchcr.company_id' )
        ->options( Options::inst()
        ->table( $wpdb->prefix . 'kolrooms_coworing_hotel_costumers' )
        ->value( 'id' )
        ->label( 'company' )
         ->order( 'company')        
    )
    ->validator( Validate::dbValues() ),

    Field::inst( 'kchr.coworing_hotel_place_id' )
        ->options( Options::inst()
        ->table( $wpdb->prefix . 'kolrooms_coworing_hotel_place' )
        ->value( 'id' )
        ->label( 'offices_name' )
        ->order( 'offices_name')        
    )
    ->validator( Validate::dbValues() )
    ->set( false ),

    Field::inst( 'kchr.floor' )
        ->set( false ),
    Field::inst( 'kchr.no' )
        ->set( false ),
    Field::inst( 'kchr.name' )
        ->set( false ),
    Field::inst( 'kchp.offices_name' )
        ->set( false ),        
    Field::inst( 'kchc.company' )
        ->set( false ),

    Field::inst( 'kchrc.cylindernameno' )
        ->set( false ),

    Field::inst( 'kchcr.cylinder_id' )
        ->options( Options::inst()
        ->table( $wpdb->prefix . 'kolrooms_coworing_hotel_rooms_cylinder' )
        ->where( 'coworing_hotel_place_id','kchr.coworing_hotel_place_id ')
        ->value( 'id' )
        ->label( 'cylindernameno' )
        ->order( 'cylindernameno')  
    )
    ->validator( Validate::dbValues() )

)
->leftJoin(  $wpdb->prefix . 'kolrooms_coworing_hotel_rooms kchr', "kchcr.rooms_id", '=', 'kchr.id' ) 
->leftJoin(  $wpdb->prefix . 'kolrooms_coworing_hotel_place kchp', "kchr.coworing_hotel_place_id", '=', 'kchp.id' ) 
->leftJoin(  $wpdb->prefix . 'kolrooms_coworing_hotel_costumers kchc', "kchcr.company_id", '=', 'kchc.id' ) 

->leftJoin(  $wpdb->prefix . 'kolrooms_coworing_hotel_rooms_cylinder kchrc', "kchrc.id", '=', 'kchcr.cylinder_id' ) 




->process( $_POST )
->json();

magnus@greatlord.com

Anyway I solv it with in another way.