[Rolf Diepeveen]

Hi Steven,

We encounter a problem with search, which is the same for a regular visitor at the front-end as for the admin part. The following happens; if I use only part of a family name, the family is sometimes shown and sometimes not. For example:

Family name: Diepenveen
Search: diep or diepe – family is shown in search results
Search: veen – family is not shown

Family name: Oudesluis
Search: oude – family is not shown
Search: oudes – family is shown

We have not been able to discover a ‘system’ en believe it might be a bug? With almost 600 connections, search is an essential function for us. I hope you can help.

Regards,
Rolf

[Steven Zahm]

@ Rolf

Sorry, but it is not likely I can do much about this. I suspect that it is the search character limit your web host has placed on your database. Most web hosts seem to set a 3 character limit for “shortwords”. Shortwords are ignored when searching the database. My guess is that your web host has this set to 4 characters instead of the typical 3 character limit. This means any word that is 4 characters or less will be ignored by the database search.

Connections does have logic in place to deal with shortwords, but only if those words are between 2–3 characters long. So, when you are searching, the 4 characters are too long to be dealt with by Connections and its shortword logic while being too short that they are discarded by the database when doing the search.

I do have to ask… how truly impactful is this? It does not seem all that likely that someone will search for less than half a name.

[Author]

Posts