Sign up for Free !!
World's first open source developer community with
Ticketing System
How to filter latest record by date in Django?
Messages(models.Model): message_from = models.ForeignKey(User,related_name=”%(class)s_from”) message_to = models.ForeignKey(User,related_name=”%(class)s_to”) message=models.CharField(max_length=140,help_text=”Your message”) created_on = models.DateTimeField(auto_now_add=True) class Meta: db_table = ‘messages’
Query:messages = Messages.objects.filter(message_to = user).order_by(‘-created_on’)[0]
Output:
message_from | message_to | message | created_on
——————|—————–|——————–|——————–
Daina | Twinkle | Hi, How are you? | 2020-10-19 14:27:48
Please Login/Register to write your answer !!!
Messages(models.Model):
message_from = models.ForeignKey(User,related_name=”%(class)s_from”)
message_to = models.ForeignKey(User,related_name=”%(class)s_to”)
message=models.CharField(max_length=140,help_text=”Your message”)
created_on = models.DateTimeField(auto_now_add=True)
class Meta:
db_table = ‘messages’
Query:messages = Messages.objects.filter(message_to = user).order_by(‘-created_on’)[0]
Output:
message_from | message_to | message | created_on
——————|—————–|——————–|——————–
Daina | Twinkle | Hi, How are you? | 2020-10-19 14:27:48