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.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

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


1198 Views

Avatar
fordy

Community Member, 46 Posts

23 June 2008 at 10:43am

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