Thread: Gift Registry search issue

I'm experiencing limited functionality with the gift registry search function. It appears the search by name function is returning only the first match which is leading to visitor confusion. IE a search for "Jen" will return "Jennifer Abbey" but not "Jenny Smith" - both are confirmed to have public registries.

ASPDNSF: 8012
IIS:7
MsSQL:2005

Follow up, has the gift registry been updated much in V9?

As far as I am aware, there were no changes with the giftregistry functionalities in v9.x, no. If the gift registry of "Jenny Smith" for example did not appear in the search result, it's possible that she turned off this "I want other customers to be able to search for my gift registry" setting in giftregistry.aspx page.

Both are confirmed to have public registries. In fact, it was during a search for a specific client's registry that we discovered this problem. The first name search returned what appears to be the first occurance of the name. A first name and last initial was required to return the correct registry.

You'll have to provide both firstname and lastname enable to get accurate results, that's the default behavior of 'Search by Name'. You could enhance that by changing the line below.

From:

Code:

public void btnSearchForName_Click(object sender, EventArgs e)
  {
     string sql = "select top 1 CustomerID,GiftRegistryGUID from Customer where ltrim(rtrim(lower(FirstName + ' ' + LastName))) like '%" + DB.SQuote(txtSearchForName.Text.ToLowerInvariant()) + "%' and GiftRegistryIsAnonymous=0 and ShippingAddressID IS NOT NULL and ShippingAddressID<>0 and GiftRegistryAllowSearchByOthers=1";
     DoSearch(sql);
 }

to:

Code:

string sql = "select top 1 CustomerID,GiftRegistryGUID from Customer where ltrim(rtrim(lower(FirstName + ' ' + LastName))) like " + DB.SQuote( "%" + txtSearchForName.Text.ToLowerInvariant() "%" + )" and GiftRegistryIsAnonymous=0 and ShippingAddressID IS NOT NULL and ShippingAddressID<>0 and GiftRegistryAllowSearchByOthers=1";

* just change the red line above with this one.