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. <[email protected]> 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 [email protected]. > 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CADMeFRHuHw4fvKD76QVu%3D7qch-Vt9S6bK8eMNrQ-H3dN%3D8ZmdA%40mail.gmail.com.
