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


Reply

987 Views

Avatar
fordy

23 June 2008 at 10:43am Community Member, 46 Posts

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