Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » FieldList items in ComplexTableField

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

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

Page: 1
Go to End
Author Topic: 941 Views
  • fordy
    Avatar
    Community Member
    46 Posts

    FieldList items in ComplexTableField Link to this post

    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

    941 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.