Hi,
Is it possible to show fields from a left join in the fieldlist of a ComplexTableField?
For example:
new ComplexTableField($this, 'ApplicationList', 'VacancyApplication', array(
'ID' => 'ID',
'AppDate' => 'Application Date',
'FirstName' => 'First name',
'Surname' => 'Surname'
),
$this->AppDetailFields()
, 'MyVacancyID = '.$id,
'',
'LEFT JOIN Member ON VacancyApplication.MyCandidateID = Member.ID'
)
I want to show the members FirstName and Surname in the list but it justs comes up blank.
Does anyone know how to make this work?
Thanks in advance