Searching record name with & symbol

  • modnine

    (@modnine)


    3 weeks ago

    Hello,

    We are having some issues with the search functionality in the plugin, specifically when the record name has an ampersand with letters surrounding it. For example, if we search for a record with the name “X&Z Construction” we get no results even though that is the name in the field. If the name instead has spaces around the ampersand (i.e. A & B Construction) it works correctly and returns the result.

    This is happening on both the front end search and admin back end search for the plugin.

    Any ideas to help fix this? Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author xnau webdesign

    (@xnau)

    I’m unable to duplicate this result in my tests, so I can’t say exactly what is going on there.

    Sometimes it is helpful to look at what is going on behind the scenes to understand the search result you’re getting. To do that, you should turn plugin debugging on, clear the debugging log, then try your searches. The log will contain the database query that was used to show the results.

    It may be necessary to take a look at the contents of the database directly to see why that search isn’t matching. You can do that by using a database tool like phpMyAdmin (usually found in your hosting control panel) and looking at the plugin’s database table wp_participants_database. This will show you exactly what is in the field you are searching on.

    Thread Starter modnine

    (@modnine)

    Thanks for the reply! I took a look in phpMyAdmin and the record is stored as T&D in the database, but on the front end it shows as T&D on the front end. Is there something we can do to have that return in the search results as well or to prevent it from getting stored this way?

    Plugin Author rolandbarker

    (@rolandbarker)

    Sorry for the late response, I had to create a new account to continue this thread.

    All plugin forms will accept ampersands and store them unencoded as a plain ampersand, so I’m not sure how it happened that that particular one got saved in its encoded form. Perhaps a CSV import?

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.