KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Imagine I have the following model: class Person(models.Model): ...other stuff... optional_first_name= models.CharField(max_length=50, blank=True) How would I go about writing a request that returns an array of the most popular names, in decreasing order of occurence, with their counts, while ignoring the empty names? i.e. for a database with 13 Leslies, 8 Andys, 3 Aprils, 1 Ron and 18 people who haven't specified their name, the output would be: [('leslie', 13), ('andy', 8), ('april', 3), ('ron', 1)] The closest I can get is by doing the following: q= Person.objects.all() q.query.group_by=['optional_first_name'] q.query.add_count_column() q.values_list('optional_first_name', flat= True) But it's still not quite what I want.
Tags (comma-separated)
Save Edits
Cancel