Word Search vs a SQL Search

Epicor 10.0.700.4

According to what I have read there is at least two types of searches; a Word search and a SQL search. In the latter search each letter is held with equal importance, rather in the Word search it maintains the first letter and subsequent letters in descending importance. When we search now, it seems to be using the SQL search and giving results based on each letter in equal proportions, rather than in the Word search. How do we change this setting? I found a ‘sort’ section in the config file is this it?

There are two types of sort options available.

StringSort- This setting is the Epicor default and in the String Sort algorithm all characters are given an equal “weight” for sort positioning.

WordSort- This setting is the Microsoft default and in the Word Sort algorithm some specialty characters are given almost no “weight” in the sort positioning. The Hyphen (-) is the most visible of these specialty characters.

What does this look like in practice? Screenshot below taken from an excellent Insights presentation on Epicor internals by our framework development team.

If you wish to use wordSort as the default but still keep the stringSort for part numbers

1 Like

Thank you for the reply. So would we need to just update the config files on the Appserver to push out to all of the clients?

Would have to change the sort settings in the .sysconfigs on the server and create an autoupdate event like changing the version value in the server’s .sysconfig or a difference in the customizations section between the copy on the server and the workstation’s .sysconfig so the new .sysconfigs get copied down (along with the releaseclient.zip). Changing just the sort settings isn’t enough to have the client copy the updated .sysconfig from the server.

Thank you! One last question, are these the only two sort options available?

wordSort and stringSort are the two sorting options currently available. Are you looking/in the need of a sort order that is different than one of those two?