Configuring OneClick restrictions

Deephaven allows system administrators to impose limitations on the values that users can enter when using OneClick filters. Two properties may be configured.

The first property will only allow text to be entered in a OneClick filter for a targeted column when it matches the specified regular expression (Regex). The syntax follows: OneClick.allowedPattern.<ColumnName>=<Regex>

• In the following example, the property limits users to enter only upper or lower case values, numbers between 0 and 9, and the period character in the USym column. OneClick.allowedPattern.USym=^[A-Za-z0-9\.]+$
• In the next example, the property limits users to enter only upper or lower case values, numbers between 0 and 9, and the @ character in the SaleCondition column.
• OneClick.allowedPattern.SaleCondition=^[A-Za-z0-9\@]+$

The second property requires the text entered in specified columns to be typed in uppercase letters. The syntax follows: OneClick.enforceUpperCaseColumns=<ColumnNames>

• For example, when the following property is configured, users must type uppercase letters when entering values in the USym column. OneClick.enforceUpperCaseColumns=USym