How to add another field to select clause?

[Alex Glaros]

How to add db.role_member.id within select clause as highlighted below?

If I leave it out, it runs fine. If I add it, I get error: 

class 'psycopg2.errors.GroupingError'> column "role_member.id" must appear in the GROUP BY

and if I make it appear in the group by section as suggested by the error message, I get error:

SyntaxError: non-keyword arg after keyword arg

Here is the code:

    distinctCount = db.object_super_object.super_object_fk.count().with_alias('distinctCount')

    

    distinctSet = db((db.role_member_status_instance.role_member_fk == db.role_member.id) & (db.role_member.role_fk == specificRoleID) & (db.role_member.object_super_object_fk == db.object_super_object.id) & (db.role_member.is_active == True) &  (db.role_member.member_super_object_fk == db.super_object.id) & (specificOrganizationID == db.object_super_object.role_owner_organization_fk)).select(db.role_member.member_super_object_fk, db.role_member.id, distinctCount, groupby = db.role_member.member_super_object_fk, db.role_member.id)

[Alex Glaros]

using Postgres 

[Jim S]

If your groupby is a list of fields then it needs list brackers [ ] around it.

Can you add that and report back?

-Jim

[Alex Glaros]

It worked Jim.   Thanks!

[Jim S]

Glad to hear you got it working.

-Jim