Minimal Character and Default Result

[div]

Hi Earnet,

I tried that previously but didn’t retrieve either of the Agents as that seems to work with exact matches. What I’m looking for is not an exact match but for the search to start from the beginning of the keyword.

Thanks

Femi

[Ernest Marcinko]

Hi Femi,

I don’t know if there is a better solution for that. I was thinking using the index table engine + OR logic, but it would yield the same results, as the reverse terms are also matched. Maybe a direct code modification, but I am not sure about that either.

[div]

Hi Ernest,
Do you think there’s a solution in view? We are planning to go live next week and I’m getting a bit worried.

Just in case I didn’t explain the issue well the other time, see attached image for a pictorial illustration. This assumes you have two records (partial post codes) in your database.

Thanks
Femi

[Ernest Marcinko]

Hi Femi,

The ‘OR with exact word matches’ would return the expected results, however the partial matching of the word beginnings would not work.

I have made a direct modification to the index table search file, so that only either word of the prhase matching any of the word beginnings (or whole words) is returned.

I this case:
– Phrase “AB10 3TU” will match anything starting with “AB10” or “3TU”
– Phrase “B10 3TU” will match anything starting with “B10” or “3TU” – but will NOT match “AB10”

This is as close as it can get. I have also enabled the index table engine for both instances, as this only works with that. Make sure that all the desired fields are selected under the index table submenu.

[div]

Hi Ernest,
I’ve done a quick test and it looks like this has worked!
Many thanks for your prompt and outstanding support

Regards
Femi

[Ernest Marcinko]

You cannot access this content.

[div]

Hi Earnest
The site has now gone live, but another issue has just come to light.

Consider 3 agents with the following post codes:
Linda – RH1 , RH2 , RH6, KT17, KT18, KT19, KT20
Michelle – RH12, RH13, RH14
Ash – UB1,UB2,UB3,UB4,UB5,UB6,W7,W13

Using the tool, if you search using keyword “RH1 4BU” you get the three agents retrieved. What we want is just for Linda only to be retrieved. Of course, we can see why Michelle is returned.

In the Agent admin section, if we record 3-character post codes with a space at the end before the comma, to make it look like 4 characters (e.g. “RH1 “), can we make the tool ensure it looks at the first 4 characters to retrieve the result?

I was initially surprised Ash was retrieved but later saw that the “4BU” is also returning “UB4”. Can this be adjusted such that only the first 4 characters of a keyword (e.g. “RH1 “) are taken into consideration during a search.

Many thanks for your help

Femi

[div]

You cannot access this content.

[Ernest Marcinko]

Hi!

In this case, I really strongly believe that the ‘or with exact matches‘ logic is the one you should be using, as it almost perfectly fits your needs.
It will definitely return only the first agent, as expected, as the post code must be matched exactly, not partially.

[Author]

Posts