Describes a filter which can be applied to a table. Replacing these instances may be more expensive than reusing them. These instances are immutable - all operations that compose them to build bigger expressions return a new instance.

Hierarchy

  • FilterCondition

Constructors

Accessors

Methods

Constructors

Accessors

Methods

  • a string suitable for debugging showing the details of this condition.

    Returns string

    String.

  • a filter condition invoking a static function with the given parameters. Currently supported Deephaven static functions:

    • inRange: Given three comparable values, returns true if the first is less than the second but greater than the third
    • isInf:Returns true if the given number is infinity
    • isNaN:Returns true if the given number is not a number
    • isNormal:Returns true if the given number is not null, is not infinity, and is not "not a number"
    • startsWith:Returns true if the first string starts with the second string
    • endsWithReturns true if the first string ends with the second string
    • matches:Returns true if the first string argument matches the second string used as a Java regular expression
    • contains:Returns true if the first string argument contains the second string as a substring
    • in:Returns true if the first string argument can be found in the second array argument.

      Note that the array can only be specified as a column reference at this time - typically the `FilterValue.in` method should be used in other cases

    Parameters

    Returns FilterCondition

    dh.FilterCondition

  • a filter condition which will check if the given value can be found in any supported column on whatever table this FilterCondition is passed to. This FilterCondition is somewhat unique in that it need not be given a column instance, but will adapt to any table. On numeric columns, with a value passed in which can be parsed as a number, the column will be filtered to numbers which equal, or can be "rounded" effectively to this number. On String columns, the given value will match any column which contains this string in a case-insensitive search. An optional second argument can be passed, an array of FilterValue from the columns to limit this search to (see dh.Column.filter).

    Parameters

    Returns FilterCondition

    dh.FilterCondition