select two labels

churchil

i want a second label called 'nachname' how can i get this?

Field::inst ( 'id_person' )
->options( Options::inst()
->table( 'personen' )
->value( 'id_person' )
->label( 'vorname' )

churchil

ps this in my staff.php

colin

Do you mean a second field, or two labels for the same field? I don't follow.

churchil

two labels for the same field

colin

The label is what's displayed on the form during editing so the user knows what the field is - it only makes sense to have a single label. What's the use case for two?

churchil

already got it

    Field::inst ( 'id_person' )
        ->options( Options::inst()
            ->table( 'personen' )
            ->value( 'id_person' )
            ->label( array( 'vorname', 'nachname') )
            ->where (function ($t) {
                $t->where( 'vorname', '', '!=');
            })
        ),

thx

churchil

how does it works when i need DATE IS NULL (like in the SQL Query)?

$t->where('date', IS NULL);