DJANGO Queryset Exclude

folder_2 = sap_menu_area.objects.exclude(folder_2 = '').values('folder_2').distinct()

from myapp.models import Entry
from django.db.models import Q

Entry.objects.filter(~Q(id=3))

/media/uploads/2020/12/05/image_8MnDL8Y.png

Using In and exclude values

Get the list of RFQ no's not in zrfq_no and delete.

zrfq_no = RFQ.objects.all().values('rfq_no').distinct()
zdel = RFQ_H.objects.exclude(rfq_no__in=zrfq_no)
zdel.delete()
obj = RFQ_H.objects.all()