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.

  1. 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\@]+$

  1. 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


Last Updated: 02 May 2019 10:32 -06:00 UTC    Deephaven v.1.20180917

Deephaven Documentation      Copyright 2016-2018  Deephaven Data Labs, LLC      All Rights Reserved