我正在尝试创建一个视图集,其中我要过滤所有具有相同参考号的记录。成员模型中有一个参考模型字段,但是它告诉我这是一个无效的字段。
这是视图:
from groups.models import Member
from ..serializers import MemberSerializer
from rest_framework import viewsets
class MemberViewSet(viewsets.ModelViewSet):
queryset = Member.objects.filter(field_name='reference')
serializer_class = MemberSerializer
这是模型:
class Member(models.Model):
user = models.ForeignKey(User, on_delete=models.CASCADE)
group = models.ForeignKey(Group, on_delete=models.CASCADE)
reference = models.CharField(max_length=22)
balance = models.DecimalField(max_digits=12, decimal_places=2)
open_tabs = models.IntegerField()
created = models.DateTimeField(auto_now_add=True)
这是URL:
from groups.api.views.memberViews import MemberViewSet
from rest_framework.routers import DefaultRouter
router = DefaultRouter()
router.register(r'', MemberViewSet, base_name='member')
urlpatterns = router.urls
所以我想滤除具有相同参考字段值的所有成员对象...
如果要在视图集中具有特定reference
的Members
,则应覆盖get_queryset
方法并将参数添加到URL中。
在视图中:
from groups.models import Member
from ..serializers import MemberSerializer
from rest_framework import viewsets
class MemberViewSet(viewsets.ModelViewSet):
serializer_class = MemberSerializer
def get_queryset(self):
reference = self.kwargs['reference']
return Member.objects.filter(reference=reference)
和在URL中:
from groups.api.views.memberViews import MemberViewSet
from rest_framework.routers import DefaultRouter
router = DefaultRouter()
router.register(r'(?P<reference>[-w]+)', MemberViewSet, base_name='member')
urlpatterns = router.urls
请参阅《 DRF过滤指南》
参考querySet
您可以尝试使用以下方法'SearchKey'
是您要查询的参考号吗?
queryset = Member.objects.filter(reference__contains='SearchKey')