Concat two columns in a checbox list after doing a join

alepervel

I have 2 tables related with a link column , one table have a name and last name columns , i want to concatenate the name and the last name into a editor form selected by a checkbox, how can i concatenate in the js??

->join(
    Join::inst( 'cat_gestor_plan', 'array' )
        ->join(
            array( 'id', 'id_proyecto' ),
            array( 'id', 'id_gestor_plan' ),
            'repos_proy_gestor_plan'
        )
        ->fields(
            Field::inst( 'id' )
                ->validator( 'Validate::required' )
                ->options( 'cat_gestor_plan', 'id', 'nom_gestor_plan' )
                                     ->options( 'cat_gestor_plan', 'id', 'apat_gestor_plan' )
        )
)

{
            "label": "Gestor del Plan:",
            "name": "cat_gestor_plan[].id", <--- concatenate name and last name (nom_gestor_plan + apat_gestor_plan)
            "type": "checkbox"
        },

Thank you!!

alepervel

Forget it , i did a sql view to resolve this .. thank you anyway