Unsupported lookup 'istartwith' for CharField or join on the field not permitted

Question

I created some models using Django ORM.

class feed(models.Model):
    location = models.OneToOneField('feedlocation')

class feedlocation(models.Model):
    areaHash = models.CharField(max_length=100,default='')

Then I used the follow code to find out the 'feed' on the same areaHash.

Feed.objects.filter(location__areaHash__istartwith='*****')

The I got this error:

FieldError: Unsupported lookup 'istartwith' for CharField or join on the field not permitted.

What should I do to achieve this query?

Answer 1

This code is incorrect :

Feed.objects.filter(location__areaHash__istartwith='*****')

Try :

Feed.objects.filter(location__areaHash__istartswith='*****')

Answer 2

Another Workaround could be using icontains (keeping case-insensitivity as @shacker noticed) :

Feed.objects.filter(location__areaHash__icontains='*****')