Add a property to count Y for each column Or add a computed field that tallies that on save
For reference https://stackoverflow.com/questions/1454727/do-properties-work-on-django-model-fields On Mon, Sep 20, 2021 at 6:41 PM J.T. <jrturner0...@gmail.com> wrote: > I have a model called member that has 6 columns: ID, Value1, Value2, > Value3, Value4, Value5 > > The values in columns Value1, Value2, Value3, Value4, Value5 are either Y > or N. > > I'm trying to query by ID to count the number of Y values for each member. > > For example one row would be: 5, Y, N, Y, N, N > > I would like to return: 2 (since that is the number of Y in that member's > row) > > I've tried using Aggregate, Annotate, F, Q, Sum, Count in different ways > and I'm missing the mark. I've been through the docs and SO for about 2 > hours. > I would post my errors but it's on my work computer and I have to post > here from my personal laptop. > > I feel like I may be over-thinking it but I can't quite figure it out. Any > help would be greatly appreciated. > > Jason > > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/597a0acf-65a0-4e9a-8a9f-b61892860789n%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/597a0acf-65a0-4e9a-8a9f-b61892860789n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CADMeFRHuHw4fvKD76QVu%3D7qch-Vt9S6bK8eMNrQ-H3dN%3D8ZmdA%40mail.gmail.com.
