Universal Search on Small Words - Everything Else https://www.augforums.com/forums/everything-else/universal-search-on-small-words/ Acumatica User Group Forums en-US Tue, 15 Sep 2026 00:00:28 +0000 wpForo 60 RE: Universal Search on Small Words https://www.augforums.com/forums/everything-else/universal-search-on-small-words/#post-5516 Thu, 14 Nov 2019 00:50:21 +0000 Thanks so much for sharing this Ryan. I've wanted to learn more about how SQL Full Text search works so this is really helpful.

Google search makes sense to me, but SQL Full Text search is still a bit of a mystery to me.

Another thought, I wonder if Acumatica SaaS allows you to tweak these options or if it's "what you see is what you get".

]]> Everything Else Tim Rodman https://www.augforums.com/forums/everything-else/universal-search-on-small-words/#post-5516 Universal Search on Small Words https://www.augforums.com/forums/everything-else/universal-search-on-small-words/#post-5314 Mon, 14 Oct 2019 20:40:43 +0000 We recently had an issue where searching in the universal search for a company name that included "IT" in the end would return no results.  After doing some digging, we discovered that IT is a stop word for full text searching in SQL and doesn't get indexed.  That caused problems because SQL would return zero results and therefore Acumatica would return zero results as well.  We ended up having to the follow the 3 steps below to remove "it" from the SQL stop list.  This does require access to SQL.  Hope this helps anyone else with similar issues.

  1. Added our own stoplist (Inside db instance, go to storage>>Full text stop lists -- right click to create a new one - we did it based on system )
  2. Removed "it" from stop list (right click on new stop list, go to properties - under actions select delete a stop word, enter stop word, click on OK)
  3. Assigned new stop list (right click on SearchIndex table, go to Full Text Index>>Properties -- In the middle you see see stop list and can use drop down)

 

]]> Everything Else Ryan Brown @xByte Hosting https://www.augforums.com/forums/everything-else/universal-search-on-small-words/#post-5314