search

open-city / councilmatic

DEPRECATED, replaced by https://github.com/datamade/chi-councilmatic
16 stars 9 forks source link

create topic dashboard for sponsor #29

Closed derekeder closed 11 years ago

derekeder commented 11 years ago

testing some queries:

phillyleg.models.LegFile.objects.annotate(num_topic=Count('metadata__topics__topic')).filter(sponsors__id=40).order_by('-num_topic')

phillyleg.models.MetaData_Topic.objects.annotate(num_legfiles=Count('references_in_legislation__legfile')).filter(references_in_legislation__legfile__sponsors__id=40).order_by('-num_legfiles')