More on OracleTextSearch deficiencies

I was so focussed on exploring multiple sort criteria with OracleTextSearch that it was pointed out to me afterwards that even a single sort criteria fails. Shonky stuff!

The MultiSort component was "fixed" in late 2009 to identify optimised fields and ignore the rest. That means it provides sorting on 5 fields only - date, title, ID, security and type. Considering there are typically just a few security groups and content types it's hardly worth using. Installing URM gives one more field. Whoopdie doo.

I'm sticking with Database.Fulltext search. Sure it's slower to rebuild and doesn't have fancy drilldown features - but it works the way it is supposed to.

OracleTextSearch: sorting by multiple fields = multiple problems

OracleTextSearch mangles the multi-sorting functionality of UCM search results. The MultiSort or SearchSortOptions components won't work, I don't know if there are newer versions that will. But the ability to sort on multiple fields is still possible, read on to figure out how to do it.