Don’t forget to enter notes” - If they have not enter note by today and enter note the prior day

user_12524474 0
Viewed 38

I have two tables Member table and Daily_Notes table.

class Member(models.Model):
    name = models.Charfield()

Daily_notes table

class DailyNotes(models.Model):
    member= models.Foreignkey('Member')
    note=models.Charfield()
    date=models.Datetimefield(default="")

Daily note table contains daily entries

I need to filter datas, If user have not enter note by today and entered the prior day.

django-rest-framework postgresql django-views django-models django
1 Answers

You can retrieve Members that have filled in a DailyNotes item the previous day and not the current day with:

from datetime import date, timedelta

Member.objects.filter(
    dailynotes__date__date=date.today() - timedelta(days=1)
).exclude(
    dailynotes__date__date=date.today()
)
user_675790
Related