I have a modelAdmin which manages CustomerSignups. I’m trying to search for records filtering for EventDate and for the ExperiencePage. CustomerSignups has_one Event which has_one ExperiencePage. The ExperiencePage filter does not work at all.
public function getDefaultSearchContext()
{
$fields = FieldList::create(
TextField::create('FirstName', 'First Name'),
TextField::create('Email', 'Email'),
DateField::create('EventDate:GreaterThan', 'Event Date From'),
DateField::create('EventDate:LessThan', 'Event Date To') ,
DropdownField::create('ExperiencePageID', 'Experience Page', ExperiencePage::get()->sort('Title', 'ASC'))->setEmptyString('-- Select an Experience Page --')
);
$filters = [
'EventDate:GreaterThan' => GreaterThanFilter::create('EventDate'),
'EventDate:LessThan' => LessThanFilter::create('EventDate'),
'Event.ParentID' => ExactMatchFilter::create('ExperiencePageID')
];
return SearchContext::create(
static::class,
$fields,
$filters
);
}
How can i filter by ExperiencePage ?