SQL query to django

[Eugene TUYIZERE]

Dear all,

I have a table let call it YY. Some fields in this table are status, time_frame, etc.

time frame is in terms of years and status are Not started, In progress and Completed. I want to display all services Not started, in progress and completed in each year.

And at the end to display this on bar chart. but What I most want is the query.

I want to transform this SQL query in Django:

SELECT status from YY group by time_frame;

please assist 

--

TUYIZERE Eugene

[carlos]

ok, try this but is only idea (i don't is working)

from django.db.models import Count

result = (YY.objects
    .values('time_frame','status')
    .annotate(timecount=Count('time_frame'))
    .order_by('status')
)

read this for understand https://docs.djangoproject.com/en/3.2/topics/db/aggregation/

if this no help you maybe this way

results = YY.objects.raw('SELECT status FROM YY GROUP BY time_frame')

and read this too for understand

https://docs.djangoproject.com/en/3.2/topics/db/sql/#topics-db-sql

Cheers

--
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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CABxpZHsysRxgE9bn9c9naLY%2BtWmKRfwpr%2BUsMYiAV_ZcPC_3Hw%40mail.gmail.com.

--

att.

Carlos Rocha

[Sebastian Jung]

Hello Eugene, 

You can also take a raw query...

https://docs.djangoproject.com/en/3.2/topics/db/sql/

Regards

[Eugene TUYIZERE]

Thank y'all

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAKGT9mzGkqVRSUjNWuU%2B1kyYB4vRCBh3ZjBTP-Ha0g71VaHyiA%40mail.gmail.com.

--

TUYIZERE Eugene

Msc Degree in Mathematical Science

African Institute for Mathematical Sciences (AIMS Cameroon)
Crystal Garden-Lime, Cameroon

Bsc in Computer Science

UR-Nyagatare Campus

Email: eugene....@aims-cameroon.org

           eugenet...@gmail.com

Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38