I have performed the following query:
$query = db_select('sage.USER', 'USER') ->fields('USER', array('USER_ID', 'OFFICE_ID', 'USER_PASSWORD')) ->range(0, 1); $result = $query->execute(); ... $url = '/sage/office-' . $result->office_id; $arguments = MigrateLinkFieldHandler::arguments(array('source_field' => 'office_id')); $this->addFieldMapping('field_office_id', $url); ->arguments($arguments);
However, the above is not working. I would like to manipulate the 'office_id' field to be used as the 'title' and the variable $url to be used as the URL that was linked. I have followed what's on this post
Could someone please point out my mistakes?
EDIT: Updated question to reflect jdu's answer.