This workaround works. In [10]: from django.db.models.functions import Lower In [11]: from django.db.models import CharField
In [12]: CharField.register_lookup(Lower, "lower") Out[12]: django.db.models.functions.base.Lower In [13]: doctor.objects.filter(name__lower__contains="joel") Out[13]: <QuerySet [<doctor: Joel>, <doctor: Jeslin Joel>]> I'm eager to solve this strange behavior though. Sincerely yours, Dr Joel G Mathew On 10 August 2018 at 17:17, Matthew Pava <[email protected]> wrote: > I’m fascinated by this problem. > > Try this workaround. > > https://docs.djangoproject.com/en/2.0/ref/models/database-functions/#lower > > > > Register the lookup Lower like so: > > CharField.register_lookup(Lower, "lower") > > > > Then use the contains lookup. > > doctor.objects.filter(name__lower__contains="joel") > > > > > > From: [email protected] [mailto:[email protected]] > On Behalf Of Joel > Sent: Friday, August 10, 2018 10:56 AM > To: Django users > Subject: Unexpected behavior with icontains in query filter > > > > I'm trying to do a case insensitive search for a substring within a field in > my model. > > > > My model: > > > > > > class doctor(models.Model): > docid = models.AutoField(primary_key=True, unique=True) # Need > autoincrement, unique and primary > name = models.CharField(max_length=35) > username = models.CharField(max_length=15) > regid = models.CharField(max_length=15, default="", blank=True) > photo = models.CharField( > max_length=35, default="", blank=True) > email = models.EmailField(default="", blank=True) > phone = models.CharField(max_length=15) > qualifications = models.CharField( > max_length=50, default="", blank=True) > about = models.CharField( > max_length=35, default="", blank=True) > specialities = models.CharField( > max_length=50, default="", blank=True) > department = models.CharField(max_length=50, default="ENT", > blank=True) > fees = models.FloatField(default=300.0) > displayfee = models.IntegerField(default=0, blank=True) > slotrange = models.CharField(max_length=50, blank=True) > slotdurn = models.IntegerField(default=10) > breakrange = models.CharField( > max_length=50, default="", blank=True) > slotsleft = models.CharField( > max_length=50, default="", blank=True) > def __str__(self): > return self.name > def Range(self): > return self.slotrange > def listslots(self): > SlotRange = self.slotrange > SlotDurn = self.slotdurn > startime = SlotRange.split('-')[0] > endtime = SlotRange.split('-')[1] > sthr, stmin = SplitTimeString(startime) > enhr, enmin = SplitTimeString(endtime) > print(stamptoday(sthr, stmin)) > print(stamptoday(enhr, enmin)) > startstamp = stamptoday(sthr, stmin) > endstamp = stamptoday(enhr, enmin) > secdurn = SlotDurn*60 > slotlist = [] > for sec in range(startstamp, endstamp, secdurn): > enttime = sec + secdurn > myrange = ("%s - %s" % (HumanTime(sec), > HumanTime(enttime))) > slotlist.append(myrange) > return slotlist > > > > > > Under the field 'name' in my mysql database, are two rows with values for > name as 'Joel' and 'Jaffy Joel'. > > > > When I do the search like this: > > > > > > from appointments.models import customer, doctor, appointment > doctor.objects.filter(name__icontains='joel') > > > > > > Output: > > > > > > <QuerySet []> > > > > > > But when I do: > > > > doctor.objects.filter(name__icontains='Joel') > > > > Output: > > > > > > <QuerySet [<doctor: Joel>, <doctor: Jaffy Joel>]> > > > > > > Why isnt the case insensitive search working for a lowercase search? > > > > I'm on django 2.0.7 > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/django-users. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/46579c92-8a12-4977-814c-9c3fcaa14711%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/django-users. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/c204f799406943208eaabb1ece752054%40ISS1.ISS.LOCAL. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAA%3Diw_9s9bEO2X89KwbzohcmyAmngNdmEMu5Ar_9TRShoFDm1g%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
