Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Archive /

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo

FieldList items in ComplexTableField

Go to End



Community Member, 46 Posts

23 June 2008 at 10:43am


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'

, '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