gistfile1.txt

$this->addFilter('first_name', [
    'className' => 'Custom',
    'method' => fn(Query $query, $field, $value, $data, $options) =>
    // debug($query->contain(['Males', 'Females'])->leftJoinWith('Profiles')),
    $query
        ->contain(['Males', 'Females'])
        ->leftJoinWith('Profiles')
        ->where([
            'OR' => [
                // $query->newExpr()->like($this->Males->Profiles->first_name, '%' . $value . '%'),
                $query->newExpr()->like($query->identifier('Females.first_name'), '%' . $value . '%'),
            ],
        ]),
]);