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, biapar, Willr, Ingo, simon_w

FieldList items in ComplexTableField




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