4
« on: February 22, 2023, 09:49:44 AM »
Character removal on the Application Group > Field Information tab is used to 'cleanup' search values entered by the end user before querying the database.
From the Administrator Client help text:
String Embedded. You can define from one to eight characters that Content Manager OnDemand removes from search values typed by the user before querying the database. Content Manager OnDemand can remove embedded, leading, and trailing characters. For example, suppose you define a field to store index values that contain phone numbers. The values in the database contain only numbers. That is, the values do not include the dash character. However, when users query the database with a phone number, they typically type search strings such as 303-555-1212. Since the database values do not include the dash character, Content Manager OnDemand would not find a document to match the query. However, you can use the Embedded field to enable users to type values that include the dash character. Simply type a dash character in the Embedded field. That way, the user can type 303-555-1212 (or 3035551212) in the search field. Content Manager OnDemand removes all occurrences of the character specified in the Embedded field from the search string typed by the user before querying the database.