Add Group By on entity find

enryson commented 1 year ago

Add Group By on entityManager.find operation

Is only possible using QueryBuilder

I preferred workin with entityManager, and would be very nice to have this implemented on. Sequelize and Primsma have this feature, i have more that 40 applications using TypeORM and all of them are using entityManager and we have some components too.

The Solution

make something similar to Sequelize. like:

userRepository.find({ groupBy: "ColumName", })

Considered Alternatives

On my case this implementation will help on my projects, and will benefit new projects. I know that is possible by using query builder, but on my case using repository the implementation is cleaner and more friendly.

Additional Context

On my work i have more that 130 developers that will benefit with this change. with more that 40 projects.

(first request on this project and sorry if my English isn't 100% accurate)

Relevant Database Driver(s)

DB Type	Relevant
`aurora-mysql`	no
`aurora-postgres`	no
`better-sqlite3`	no
`cockroachdb`	no
`cordova`	no
`expo`	no
`mongodb`	no
`mysql`	yes
`nativescript`	no
`oracle`	no
`postgres`	no
`react-native`	no
`sap`	no
`spanner`	no
`sqlite`	no
`sqlite-abstract`	no
`sqljs`	no
`sqlserver`	no

Are you willing to resolve this issue by submitting a Pull Request?

✖️ Yes, I have the time, and I know how to start.
✖️ Yes, I have the time, but I don't know how to start. I would need guidance.
✅ No, I don’t have the time, but I can support (using donations) development.
✖️ No, I don’t have the time and I’m okay to wait for the community / maintainers to resolve this issue.