Mjoin - additinal fields besides the composite keys

Mjoin - additinal fields besides the composite keys

we0038we0038 Posts: 39Questions: 13Answers: 1

In the 1-to-Many example here
is it possible to have additional fields in table user_permission
for example expiry_date user_id | access_id | expiry_date
how to read this new field considering the example code? and is it possible to have preCreate event inside the Mjoin?

Editor::inst( $db, 'users' )
    ->field(
        Field::inst( 'users.first_name' )
    )
    ->join(
        Mjoin::inst( 'permission' )
            ->link( 'users.id', 'user_permission.user_id' )
            ->link( 'permission.id', 'user_permission.access_id' )
            ->order( 'name asc' )
            ->fields(
                Field::inst( 'id' )
                    ->validator( 'Validate::required' )
                    ->options( Options::inst()
                        ->table( 'permission' )
                        ->value( 'id' )
                        ->label( 'name' ),
                Field::inst( 'name' )
            )
    )
    ->process($_POST)
    ->json();

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin
    Answer ✓

    I'm sorry no. At the moment the server-side libraries assume that the link table will only have the linking reference keys. It does not allow for other meta data. That is a limitation I'm aware of and it does need to be addressed in future, but we haven't yet scoped out that work.

    Allan

  • we0038we0038 Posts: 39Questions: 13Answers: 1

    thanks for your prompt answer. there's always an alternative which in my case even makes my software better. So I guess thanks for this limitation.

This discussion has been closed.