You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Aug 13, 2021. It is now read-only.
masitko
changed the title
PostgreSQL when aggregate and group by custom column with camel-cased columnName
PostgreSQL error when aggregate and group by custom column with camel-cased columnName
Feb 3, 2016
@masitko in this case what is the outcome when running:
UserLogin.find().sum('count').groupBy('user')
The point of the columnName is so that the mapping on the backend can perform this for you. You should only use the defined attributes you supply in queries.
There is a problem when using PostgreSQL and trying to aggregate and group data by column with custom camel-cased columnName.
For an example:
If we try to group users by userId column:
created statement will trigger two errors in PostgreSQL:
as we can see userId is missing required in this case double quotes.
The text was updated successfully, but these errors were encountered: