Let's say I have query set A.
A.annotate(c=Count(Case(When(name='Jack',then=I)
Now, each time A.name == 'Jack', c will be set to I. How can I increment I for each time this happens? So that for the first case, I = 1, for the 2nd I=2 etc.
Asked
Active
Viewed 442 times
0
Mitchell van Zuylen
- 3,905
- 4
- 27
- 64
-
Could you not just iterate over the queryset and count by hand? – marcusshep Jul 28 '17 at 12:55
-
I could, but that would end up being to costly for my `sqlite`. It's already hitting plenty of `database is locked` errors. – Mitchell van Zuylen Jul 28 '17 at 13:00
-
1Don't use sqlite? – marcusshep Jul 28 '17 at 13:36
-
To late for that now :/ – Mitchell van Zuylen Jul 28 '17 at 13:42
-
`A.annotate(c=Count(Case(When(name='Jack',then=I+1), default=I)))` ?? – alfonso.kim Jul 28 '17 at 13:46