Merge string in attributes

If i need create a SELECT with authors ('id' as value and 'lastname' and 'firstname' as name) i use: {{ select('author', author, 'using': ['id', 'lastname']) }}

How i can merge lastname and firstname here? Construction with tilda didn't work: {{ select('author', author, 'using': ['id', 'lastname'~'firstname']) }}



Create the query joining the lastname with the firstname:

$this->view->authors = 
           ->columns('id, CONCAT(lastname, " ", firstname) AS realname')

Then in the View: ```php {{ select('author', author, 'using': ['id', 'realname']) }} ```


This is solution that i use:

$this->view->authors = $this->modelsManager->createBuilder()
                ->columns(array("id", "CONCAT(lastname, ' ', firstname) AS fullname"))