Opened 10 years ago

Last modified 4 years ago

#13033 new New feature

MySQL full text search in admin

Reported by: Simon Litchfield Owned by: nobody
Component: contrib.admin Version: master
Severity: Normal Keywords:
Cc: Joseph Gordon Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no


Full text search hasn't been implemented properly in admin. The query is being word split and OR'd like regular fields.

Attached patch fixes this, allowing you to type in any mysql boolean search.

Simply prefix your admin search_fields with @ to use, eg ('@myfield', ).

Be sure to include ALL the fields you have included in your index, else mysql might not use the full text index and instead default back to running a standard LIKE query.

BTW, I can't recall the various search_field operators mentioned in docs?

Attachments (1)

admin-fulltext-12288.diff (1.4 KB) - added by Simon Litchfield 10 years ago.

Download all attachments as: .zip

Change History (11)

Changed 10 years ago by Simon Litchfield

Attachment: admin-fulltext-12288.diff added

comment:1 Changed 10 years ago by Simon Litchfield

To clarify, this was already half implemented. This finishes the job. So isn't really a new feature, just a fix :-)

comment:2 Changed 10 years ago by Russell Keith-Magee

Triage Stage: UnreviewedAccepted

This isn't a bug fix -- there is nothing in the docs that says that search_fields allows full boolean searches. However, given that we're exposing MySQL Fulltext indexes, it makes sense that we should support them.

comment:3 Changed 9 years ago by Luke Plant

Type: New feature

comment:4 Changed 9 years ago by Luke Plant

Severity: Normal

comment:5 Changed 9 years ago by Julien Phalip

Needs documentation: set
Needs tests: set

comment:6 Changed 8 years ago by Aymeric Augustin

UI/UX: unset

Change UI/UX from NULL to False.

comment:7 Changed 8 years ago by Aymeric Augustin

Easy pickings: unset

Change Easy pickings from NULL to False.

comment:8 Changed 7 years ago by Aymeric Augustin

Related: #15961

comment:9 Changed 5 years ago by Joseph Gordon

Cc: Joseph Gordon added

comment:10 Changed 4 years ago by Sasha Gaevsky

Has patch: unset
Needs documentation: unset
Needs tests: unset
Note: See TracTickets for help on using tickets.
Back to Top