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.

Tinkering with the search query

Sometimes the search query isn't enough. Sometimes the administrator needs to add a few restrictive clauses or maybe inject some SQL to tweak the results. Content Server is very careful about tidying up search strings which means that modifying search behaviour is not something that can be done with Idoc. But access points do exist that provide a safe way to unobtrusively alter the query.

Multilingual Websites

A few years ago I wrote a system that produced multilingual websites in UCM. I was asked about it recently so I thought I'd talk about the solution here.

Static Publish of Query String URLs & Dynamic Pages

The Site Studio Publisher (SSP) and the pre-11g versions (SSPU) are tools that take your virtual dynamic SiteStudio website and convert it into a bunch of fair-dinkum files. This does mean that all "dynamic" functionality is lost, including any query string variables in the URL. But there actually is a way for SSP to produce multiple pages from a URL query string.

The Secret to Unlimited Search Results

The Content Server search results can't go past the first 200 items. This frustrates users and developers. By comparison, Google reports millions of results. Why does UCM, with potentially millions of content items, stop at 200? The answer is that just because the interface stops, you don't have to as well.