Issue 546: Quick Search does not locate some entries easily
- Object
- St Andrew's Fair (Dance)
- Submitter
- James Wilson
- Assigned to
- Anselm Lingnau
- Priority
- Normal
- Disposition
- Needs help
- Description
-
This dance is not easy to locate in the database. As a programmer, I am intrigued by this. Instead you have to give it a search phrase such as: andrew and scroll through a number of approximate matches.
The Montgomeries’ Rant has the same problem. Is there a work around / fix for this ?
Previous Actions
- Date Nov. 4, 2014, 5:07 p.m.
- User Unknown
New issue submitted
- Date Nov. 4, 2014, 11:50 p.m.
- User Anselm Lingnau (anselm)
Assigned changed to »anselm« (previously »None«)
Disposition changed to »Needs help« (previously »New«)
I just searched for “St Andrew’s Fair“ using the quick-search facility and the correct dance did come up as an exact match. (However this requires you to get the apostrophe just right, which is probably less than optimal.) The same applies to “The Montgomeries’ Rant“.
Can you explain in more detail exactly which search facility (out of the several on offer) you tried – the quick search, the complex search, or the search box at the top right of the overview tables? Exactly what did you enter and what result did you expect? Thank you for your trouble, and sorry for any inconvenience.
- Date Nov. 5, 2014, 12:30 a.m.
- User Eric Ferguson (EricFerguson)
Hi Anselm. Could it be due to the different codes used to represent apostrophe’s? A search with " Montgomeries’ " typed in works OK. If I copy "Montgomeries’ " from a Word document (that apostrophe looks like a lone acute accent) the search fails.
Suggestion: make all “apostrophe” codes work alike throughout the site. Eric
- Date Nov. 5, 2014, 12:32 a.m.
- User Anselm Lingnau (anselm)
That sounds eminently plausible. I do try to sanitise input strings when they are written to the database, but AFAIR not for the search boxes. I should probably add that at some point.