Skip to content

Instantly share code, notes, and snippets.

@lakinwecker
Created August 24, 2019 00:10
Show Gist options
  • Save lakinwecker/0511a351e6fe84db338b9e7eb8b90603 to your computer and use it in GitHub Desktop.
Save lakinwecker/0511a351e6fe84db338b9e7eb8b90603 to your computer and use it in GitHub Desktop.
#---------------------------------------------------------------------------
def get_queryset(self):
qs = self.filter_by_vcs(super().get_queryset())
qs = qs.annotate(
postings=Count(
'opportunity',
filter=Opportunity.objects.active_predicate(),
distinct=True,
)
)
self.ordering = 'member__name'
ordering = ['member__name']
o = self.request.GET.get('o', '')
if o in ['postings', '-postings']:
self.ordering = o
ordering = [o, 'member__name']
qs = qs.order_by(*ordering)
qs.select_related('member')
return qs
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment