$regexMatch support

[Kixell-NicolasJardillier]

Hi all,

you confirm that $regexMatch is not supported, right ?
https://docs.mongodb.com/manual/reference/operator/aggregation/regexMatch/

Best

[Smolevich]

$regexMatch isn't supported yet

[Kixell-NicolasJardillier]

Ok. As this kind of operator still not exist, it will be hard to manage aggregate properly in some case.
In my case, I need to aggregate based on a field that contain a particular string.
I ll try in other way.
Thanks @Smolevich for your quick answer

[Smolevich]

@nicoja we can implement support this operator $regexMatch

[Kixell-NicolasJardillier]

Clearly, it should be nice.
I just tried $text operator in $match (https://docs.mongodb.com/manual/tutorial/text-search-in-aggregation/)
But clearly performances are not good enough (after 'text' index creation of course)
Thus, if you plan to integrate $regexMatch I ll wait for this, sure.
Best

[GromNaN]

The query builder has a regex operator to match documents:

$regex = new \MongoDB\BSON\Regex('^acme$', 'si');
$builder->where('name', 'regex', $regex)

laravel-mongodb/tests/Query/BuilderTest.php

Lines 808 to 812 in e6de900

	$regex = new Regex('^acme$', 'si');
	yield 'where BSON\Regex' => [
	['find' => [['name' => $regex], []]],
	fn (Builder $builder) => $builder->where('name', 'regex', $regex),
	];

The $regexMatch is an other operator to filter an embedded list, it can be used with the project method:

$regex = new \MongoDB\BSON\Regex('^acme$', 'si');
$builder->project([
    'categories' => [
        '$regexMatch' => [
            'input' => '$categories',
            'regex' => $regex,
        ],
    ],
]);

You can also use the Aggregation Builder:

Model::aggregate(
    new MongoDB\Builder\Pipeline(
        MongoDB\Builder\Stage::project(
            categories: MongoDB\Builder\Operator::regexMatch(
                input: '$categories',
                regex: new \MongoDB\BSON\Regex('^acme$', 'si'),
            ),
        ),
    ),
);