whereColumn feature missing

[joseraul]

Hi!

I think is not possible to use the whereColumn, right?
Is there any special reason because it is not implemented?
I will be happy to help :)

[jazz7381]

any update about this?

[joseraul]

Not from my side.
I'm afraid I'm not using Mongo right now, so I don't have plans on working on this.

[peterlembke]

Adding a use case for whereColumn.
We recalculate items every day that is within the period (date_first_in_period, date_last_in_period).

        $builder = BenchmarkCacheModel::query()
            ->where('filter_alias', $filterAlias)
            ->whereColumn('date_last_in_period', '>=', 'updated_at');

        $keyItemArray = $builder->get()->toArray();

Unfortunately this does not work since whereColumn is not implemented: "BadMethodCallException: This method is not supported by MongoDB"

MongoDb itself can do this with aggregations. I will have to solve this for now with a raw call.

        $aggregationArray = [
            [
                '$match' => [
                    'filter_alias' => $filterAlias,
                    '$expr' => [
                        '$gte' => [
                            '$date_last_in_period',
                            '$updated_at'
                        ]
                    ]
                ]
            ]
        ];

[bisht2050]

Tracked with PHPORM-138.

[GromNaN]

This would be possible only if we convert Query Builder to Aggregation Builder. There is some limitation on the query operators that can be used, that's why we didn't implement it in #2738.

The solution would be to write an aggregation like mentioned by @peterlembke in the previous comment.