Setting Substring back as default search operator
By Kyle Hatlestad on Feb 16, 2010
For customers that grew up using UCM (aka Content Server) on Verity, one of the default configurations for search was the metadata operator being defaulted to 'Substring'. But in moving to database searching, that default operator switched to 'Matches'. This means the entire word/phrase must be entered to be found.
To go back to the old way of having Substring be default, you can add this configuration entry:
Keep in mind that the reason this was changed is because this is an expensive query to make compared to 'Matches'. So depending on the repository size, this may have an impact on the speed of the search results. One other thing to note is it does only apply the default to the free text metadata fields and not the option list fields. They will still be 'Matches' assuming the user will be picking from the list.
UPDATE (07/09/2012): For setting the default operator for an option list, you can set the configuration flag of:
In this case setting it to 'Starts' as the default.