Joe Sak

Modifying DotNetNuke Search and Improving the Results

Saturday, July 14th, 2007 | Artemis Solutions Group, Custom Development, DotNetNuke, Improving Code, Open Source, SEO, Search Engines, Search Modules, Search Results, Stored Procedure Improvement, Usability, Web Development, Websites, Work Stuff

Recently, I modified the Stored Procedure named “GetSearchResults” to improve the results pages in DotNetNuke web sites. Here is my explanation from the DNN forums.

OK — here is where the actual change is:

——————–

AND (sw.Word like ‘%’ + @Word + ‘%’)

AND (t.IsDeleted = 0)

AND (t.DisableLink = 0)

AND (m.IsDeleted = 0)

AND (t.PortalID = @PortalID)

OR (m.ModuleTitle like ‘%’ + @Word + ‘%’)

———–

The bolded lines are the changes

First line is how the search term is matched. Instead of exact, it does a like. We found that a lot of clients would complain that searching “map”, for instance, would not return pages which had the word “maps” on them. Or “auto” won’t give you “automobile”.

Second is the disablelink line. We had the problem of hidden pages showing up in results but realized sometimes we WANT hidden pages to show up, but sometimes we hide pages because they’re not ready to be published. So I decided that if I “disable” the page then I definitely don’t want it to come up in the results, but I might want to keep it for later (we aren’t much for deleting pages around here)

Third is the OR m.ModuleTitle like ‘%’ + @Word + ‘%’ part — now this is kind of a subjective one. I have a web site right now for a client that sells insurance. Home insurance, life insurance, and car insurance. When I searched “car” I didn’t get the car insurance page at all, even though the page was titled car insurance and the module was titled car insurance… The content copy used the word “automobile” because this particular client is very traditional and was picky about that wording. So I added the “OR” line because if we put the search term in the title, it’s most likely relevant. We know module titles are what show up as the links on the SRP and so we make sure those titles are always relevant and helpful for the user.

BUT — we would like to see page name or page title as an option in the settings for how the text displays. we couldn’t figure out how to modify the core to do that.

OK that is all i hope this has been informational

7 Comments to Modifying DotNetNuke Search and Improving the Results

Leave a comment