Select all with latest timestamp in django?

Question

This seems like it should be obvious but I can't get it to work.

I'm using django to query a simple table into which a bunch of data gets inserted periodically. I'd like to write a view that only pulls data with the latest timestamp, something like

select * from mytable
where event_time = (
    select max(event_time) from mytable);

What's the proper syntax for that?

Answer 1

You can try with latest method. Here documentation

MyModel.objects.latest('event_time')

assuming event_time has a date value, this will return the latest object (the max date)