Event hasMany Registration hasOne Member
// Registrations
$regTablefield = new DataObjectManager(
$this,
'Registration',
'Registration',
array(
'Member.Nickname' => 'Username',
'Member.FirstName' => 'First Name',
'Member.Surname' => 'Surname',
'Member.DateOfBirth' => 'DOB',
'Paid' => 'Paid'
),
null,
"`EventID` = '$this->ID'"
);
$regTablefield->setAddTitle( 'Attendee' );
$fields->addFieldToTab( 'Root.Content.Registrations', $regTablefield );
DataObjectManager supports drop-down custom filters, but as far as I can tell this will simply filter exact matches. What I'd like to be able to do is have a filter for example that will list all Registrations in which the Member will be less than 18 at the time of the event (using Member.DateOfBirth and Event.StartDate).
Is this possible using DataObjectManager?