I am doing a left join using select_related() and then excluding few things based on condition using below code
class ActiveclientViewSet(viewsets.ModelViewSet):
queryset = Ruledefinitions.objects.select_related('pmdclinicalruleid').filter(pmdclinicalruleid__effectivedate__lt = timezone.now(),pmdclinicalruleid__retireddate__gt = timezone.now()).exclude(Q(rulename__isnull=True) | Q(rulename__exact='') | Q(rulename__startswith='OptumFormulary'))
The above code applies exclude for entire select_related results. Instead i need to apply exclude only for first result item from select_related(). Any way to implement this?
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…