If your groupby is a list of fields then it needs list brackers [ ] around
it.
Can you add that and report back?
-Jim
On Friday, November 27, 2020 at 2:01:17 AM UTC-6 alexg...@gmail.com wrote:
> using Postgres
>
> On Thursday, November 26, 2020 at 11:18:00 PM UTC-8 Alex Glaros wrote:
>
>> 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)
>>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/e29344a9-ce6d-4940-8de9-3669319ed49en%40googlegroups.com.
