Search > Phone Numbers

Support has been upgraded!



The Support Forum is closed. Not to worry!  Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.

Premium Support

Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?

Please open a Support Ticket in your user account.

Click here to open a support ticket.

Free Support

Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.

Please open a new support topic in the WordPress support forums for Connections.

Click here to open a support topic.

This topic is: resolved

Tagged: , ,

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • 04/24/2015 at 6:30 pm #332405
    Mike Nolan
    Participant

    Hi Steven,
    I have received some feedback of users of my site, NocorkageFees.com regarding the (Connections) search feature…
    It is an issue with the search for area codes.
    Searching for “510” versus “(510)” yields are different set of search results.
    All of my current phone number entries are in the “(510)” format.
    So, if the parenthesis are an issue, is there any way to systematically remove them?
    Would this require a MySQl search and replace or something similar?
    If so, can you point me to any resources on how to make that happen?
    Anything you have to say or recommend would be greatly appreciated.
    Thanks,
    MN

    04/25/2015 at 9:38 am #332425
    Steven Zahm
    Keymaster

    @ Mike

    re: Searching for “510” versus “(510)” yields are different set of search results.

    This is not surprising as they are completely different strings.

    How is your search setup (Connections : Settings admin page, Search tab)? What fields are you letting the search, search? Just the phone numbers? If is more than just the phone numbers, results from the other fields will also be included.

    Something else will influence results too…

    The string (510) is 5 characters. The a FULLTEXT search would be applied so you would get weighted results that would include both (510) and 510. If no results are found with a FULLTEXT query, then it’ll try a LIKE query. Following the same rules as explained in the next paragraph the with exception of the results being returned will be those that start with (510). This would not include any results for 510 because that is not what is being search for for by the user.

    The string 510 is 3 characters the database will not perform a FULLTEXT search with just 3 characters. There’s nothing I can do about that. What happens instead, Connections will fallback to a LIKE query. This will return results that begin with 510 and not (510 because that is not what is being search for by the user.

    All that said… I really do not have any recommendations other than maybe you could create predefined links that search by area code. The link would really be true areacode searches but it would provide your users constant results since they would be searching for the same string.

    Hope that helps!

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)

You cannot reply to this support topic. Please open your own support topic.