Django-rest-framework: Unsupported lookup 'eq' for SmallIntegerField or join on the field not permitted.

Created on 11 Jun 2016  路  1Comment  路  Source: encode/django-rest-framework

Error Info:
Unsupported lookup 'eq' for SmallIntegerField or join on the field not permitted.

model

class item(models.Model):
    status_CHOICES = (
        ('0', 'die'),
        ('1', 'on'),
    )
    status =   models.SmallIntegerField('online status', choices=status_CHOICES,default='0')
    itemId =  models.BigIntegerField('item id',unique=True)
    ondate = models.DateTimeField('die datetime')

Serializer

class itemSerializer(serializers.ModelSerializer):

    class Meta:
        model = item
        fields = ('id','status ','ondate','itemId')

View

class itemViewSet(viewsets.ModelViewSet):
    serializer_class = itemSerializer
    queryset = item.objects.all()
    def get_queryset(self):
        return self.queryset.filter(ondate__gt = timezone.now()).filter(status__eq = 1)

Most helpful comment

i fix it

change view file

status__eq = 1 change to status = 1

class itemViewSet(viewsets.ModelViewSet):
    serializer_class = itemSerializer
    queryset = item.objects.all()
    def get_queryset(self):
        return self.queryset.filter(ondate__gt = timezone.now()).filter(status = 1)

>All comments

i fix it

change view file

status__eq = 1 change to status = 1

class itemViewSet(viewsets.ModelViewSet):
    serializer_class = itemSerializer
    queryset = item.objects.all()
    def get_queryset(self):
        return self.queryset.filter(ondate__gt = timezone.now()).filter(status = 1)
Was this page helpful?
0 / 5 - 0 ratings

Related issues

tomchristie picture tomchristie  路  3Comments

gabn88 picture gabn88  路  3Comments

jpocentek picture jpocentek  路  3Comments

thnee picture thnee  路  3Comments

MadWombat picture MadWombat  路  4Comments