Welcome to the Cookbook

When you are using virtualFields and models with aliases that are not the same as their name, you can run into problems as virtualFields do not update to reflect the bound alias. If you are using virtualFields in models that have more than one alias it is best to define the virtualFields in your model's constructor

function __construct($id = false, $table = null, $ds = null) {
	parent::__construct($id, $table, $ds);
	$this->virtualFields['name'] = sprintf('CONCAT(%s.first_name, " ", %s.last_name)', $this->alias, $this->alias);
}

1. function __construct($id = false, $table = null, $ds = null) {
2. parent::__construct($id, $table, $ds);
3. $this->virtualFields['name'] = sprintf('CONCAT(%s.first_name, " ", %s.last_name)', $this->alias, $this->alias);
4. }

This will allow your virtualFields to work for any alias you give a model.