withCount is not working

[Rahul-codoffer]

• Laravel-mongodb Version: 4.3
• PHP Version:8.3.7

Description:

Getting This method is not supported by MongoDB. Try "toMql()" instead on withCount function

[omerkoseoglu]

+1

[Rahul-codoffer]

@omerkoseoglu ?

[GromNaN]

Could you please provide a sample code to reproduce the issue. Some features are not supported with MongoDB or require some additional work.

[hooman-mirghasemi]

I have same problem in laravel 10 php 8.3 and this package latest version 4.5

[GromNaN]

@hooman-mirghasemi Same question.

Could you please provide a sample code to reproduce the issue. Some features are not supported with MongoDB or require some additional work.

[hooman-mirghasemi]

make a model in mysql "post"
then make an other one in mongo db "comments"
make hybrid relationships

Post::withCount('comments')->get();

[MiladAheshmeh]

same problem

[MiladAheshmeh]

@jenssegers would you please fix this issue?

[alcaeus]

@MiladAheshmeh please refrain from pinging people directly, especially as they no longer maintain the library. We are aware of the issue and will fix it in due time. If you'd like to help speed up the process, creating a pull request with a failing test case is a great way to do so!

[arjundexbytes]

Same issue with me

[Athul-Suresh]

Same issue with me also
"php": "^8.2",
"laravel/framework": "^12.0",
"mongodb/laravel-mongodb": "^5.4",

Sample Code

Post::where('status",1)->withCount('comments')->get()

Error:
"message": "This method is not supported by MongoDB. Try "toMql()" instead.",
"exception": "BadMethodCallException",

[alcaeus]

We are tracking this internally as PHPORM-238 and will close out this issue once we've added support for withCount.

[Athul-Suresh]

We are tracking this internally as PHPORM-238 and will close out this issue once we've added support for withCount.

Thanks for the update!