You cannot search with spaces if search_fields is declared with "^"

[Martín Conte Mac Donell <Reflejo@…>]

That is. When search_fields is declared to "starts with" you cannot perform queries with spaces.

File contrib/admin/views/main.py; Line 326:

for bit in self.query.split():
    or_queries = [models.Q(**{construct_search(field_name): bit}) for field_name in self.search_fields]
    other_qs = QuerySet(self.model)
    (...)
    qs = qs & other_qs

So, if for example i'm looking for "Hey dud" query will be:

qs.filter(field__startswith="Hey") & qs.filter(field__startswith("dud"))

[Karen Tracey <kmtracey@…>]

Code is same here on trunk and nfa, this should not block merge.

[diafour]

django-6933-0.diff patch gives ability to use search strings with spaces.

You can define such strings with '"' (like google):

'hey dud' interprets like qs.filter(fieldstartswith="Hey") & qs.filter(fieldstartswith("dud"))

and '"hey dud"' interprets like qs.filter(fieldstartswith="hey dud")

The algorithm is very basic and don't check a string for paired quotes. So '"hey dud' works like '"hey dud"'.

[diafour]

Fix tabs in a patch.

[Honza Král]

Please take a look at django.utils.text.smart_split for the splitting tool. And document this feature.

[diafour]

New patch use smart_split from django.utils.text.

[diafour]

django-6933-1.diff patch updated with addition to docs/model-api.txt

[Honza Král]

thanks diafour. I just think that the doc patch should reffer to docs/admin.txt, but that's probably just a minor glitch

[Julien Phalip]

#15203 was closed as a dupe. It reports the same problem but when the field name starts with =. It has a much more current patch too.

[Karen Tracey]

#17039 reported this again. Also given the current behavior is documented (​https://docs.djangoproject.com/en/1.3/ref/contrib/admin/#django.contrib.admin.ModelAdmin.search_fields) I'd call this ticket a new feature, not a bug. Also, I don't see that the doc mentioning the inability to search exactly on phrases with spaces is changed by the newest patch here so I think there is some doc change needed in addition to what is added by the patch.

[Lev Lybin]

Django 2.1.7 same behavior.

[Alix Léger]

​PR

[Mariusz Felisiak <felisiak.mariusz@…>]

In 26a41350:

Fixed #6933 -- Added support for searching against quoted phrases in ModelAdmin.search_fields.