Is it possible to show fields from a left join in the fieldlist of a ComplexTableField?
new ComplexTableField($this, 'ApplicationList', 'VacancyApplication', array(
'ID' => 'ID',
'AppDate' => 'Application Date',
'FirstName' => 'First name',
'Surname' => 'Surname'
, '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