Please post the code of Model and explain what do you want as Queryset?
On Fri, 25 Oct 2019 at 17:26, Cheda me <[email protected]> wrote: > Hey guys, > > I have worked out the SQL query I would like to implement but am currently > struggling to create the Django query. I have been attempting to use the > .aggregate() & Max() methods but cant seem to get the right result. Any > help is much appropriated. > > SELECT temp.* > FROM item_detail temp > INNER JOIN > (SELECT item, MAX(created_date) AS MaxDateTime, MAX(id) AS MaxID > FROM item_detail > WHERE approved = true > GROUP BY item) grouped_join > ON temp.item = grouped_join.item > AND temp.created_date = grouped_join.MaxDateTime > AND temp.id = grouped_join.MaxID > > > CREATE TABLE item_detail > ( > id INT, > item INT, > created_date TIMESTAMP, > description VARCHAR(10), > approved BOOLEAN > > ); > > INSERT INTO item_detail VALUES(1, 1, '2009-04-03', 'dk', true); > INSERT INTO item_detail VALUES(2, 1, '2009-04-03', 'dk mama', false); > INSERT INTO item_detail VALUES(3, 1, '2009-03-04', 'dk 2', true); > INSERT INTO item_detail VALUES(4, 2, '2009-03-04', 'botw', true); > INSERT INTO item_detail VALUES(5, 2, '2009-04-04', 'botw 2', true); > INSERT INTO item_detail VALUES(6, 3, '2009-03-05', 'cod mw', true); > INSERT INTO item_detail VALUES(7, 4, '2008-12-25', 'bf 4', true); > INSERT INTO item_detail VALUES(8, 4, '2009-01-05', 'bf mw', false); > INSERT INTO item_detail VALUES(9, 2, '2009-04-06', 'botw 4', false); > INSERT INTO item_detail VALUES(10, 3, '2009-04-06', 'cod newy', false); > INSERT INTO item_detail VALUES(12, 1, '2009-04-07', 'dk ea', false); > INSERT INTO item_detail VALUES(13, 1, '2009-05-08', 'dk 3', true); > INSERT INTO item_detail VALUES(14, 1, '2009-05-08', 'dk 3-3', true); > > > Here is the link to the SQL Fiffle: http://www.sqlfiddle.com/#!17/260b62/1 > > -- > 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/88f11149-eb65-4d0b-ad6e-729d9db6c6d2%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/88f11149-eb65-4d0b-ad6e-729d9db6c6d2%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/CAPTaHEufZJ6Y1V4e4zYtKJbzJa3Q1aTQMxY6f1SJDCR6auBcNw%40mail.gmail.com.
