Changes between Initial Version and Version 1 of Ticket #34413, comment 9
- Timestamp:
- Mar 13, 2023, 5:53:59 PM (21 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #34413, comment 9
initial v1 6 6 {{{#!python 7 7 User.objects.annotate( 8 first_permission =Permission.objects.filter(8 first_permission_id=Permission.objects.filter( 9 9 groups__users=OuterRef('pk') 10 10 ).order_by('name')[:1] … … 16 16 user.*, 17 17 ( 18 SELECT permission. *18 SELECT permission.id 19 19 FROM permission 20 20 JOIN group_permissions ON (group_permissions.permission_id = permission.id) … … 26 26 FROM user 27 27 }}} 28 29 Isn't this report more about the ability of subquery to return more than one column?