A logical grouping filter used to apply multiple filters together using AND or OR logic.
Combination filters enable complex conditional logic by nesting different filters into a tree structure.
The list of filters to combine using the specified operator.
This list may contain any combination of core filter types, including nested combination filters.
No properties
Type discriminator for a combination filter. Identifies this object as a logical combination of sub-filters.
"\"combination\""
The logical operator to apply when evaluating the list of filters (e.g., AND, OR).
Logical operators used to join multiple filters inside a combination filter.
"AND" | "OR"
"AND"
"OR"
A filter type for evaluating date fields in a grid dataset.
Date filters enable both exact and relative comparisons of date values and are essential
for time-series or event-driven data. LyteNyte Grid expects date values to follow a standard
ISO string format like "2025-02-01 12:00:11-02:00"
.
If filtering on timestamps or partial dates, be mindful of timezone offsets and whether time components are relevant to your comparison.
Type discriminator used to identify this filter as a date-based filter.
Helps distinguish between multiple filter types when working with compound filters.
"\"date\""
The comparison operator to apply. Determines how the field value is matched
against the provided filter value
.
Refer to FilterDateOperator for the complete set of options.
Optional configuration to control how the date is parsed and compared.
For example, setting includeTime
enables precise comparisons down to milliseconds.
The comparison value used by the filter.
This may be:
The exact type depends on the operator in use.
null | string | number
null
string
number
Set of valid comparison operators for evaluating date-based filters.
These operators support both fixed comparisons (e.g., "equals", "before") and dynamic relative date expressions (e.g., "n_days_ago", "last_week", "is_weekend").
The required type of the value
field depends on the selected operator.
"equals" | "not_equals" | "before" | "before_or_equals" | "after" | "after_or_equals" | "year_to_date" | "this_week" | "this_month" | "this_year" | "last_week" | "last_month" | "last_year" | "next_week" | "next_month" | "next_year" | "today" | "tomorrow" | "yesterday" | "week_of_year" | "quarter_of_year" | "is_weekend" | "is_weekday" | "n_days_ago" | "n_days_ahead" | "n_weeks_ago" | "n_weeks_ahead" | "n_months_ago" | "n_months_ahead" | "n_years_ago" | "n_years_ahead"
"equals"
"not_equals"
"before"
"before_or_equals"
"after"
"after_or_equals"
"year_to_date"
"this_week"
"this_month"
"this_year"
"last_week"
"last_month"
"last_year"
"next_week"
"next_month"
"next_year"
"today"
"tomorrow"
"yesterday"
"week_of_year"
"quarter_of_year"
"is_weekend"
"is_weekday"
"n_days_ago"
"n_days_ahead"
"n_weeks_ago"
"n_weeks_ahead"
"n_months_ago"
"n_months_ahead"
"n_years_ago"
"n_years_ahead"
Optional modifiers to customize date filter evaluation behavior.
Includes options like null handling and whether time values should be considered during comparisons.
If true, includes time components (hours, minutes, seconds) when comparing date values.
By default, only the calendar date is compared. Enabling this flag allows for high-precision filtering, which is useful for timestamp-based data (e.g., log entries or event schedules).
boolean
Controls how null
values are treated when applying the filter.
"ignore"
: Excludes rows where the value is null
"include"
: Retains rows with null
valuesNote: Actual behavior depends on the row data source. Properly implemented sources will
respect this setting, but others may not. Additionally, this setting may be ignored by some
filter operators. For instance, equality checks may treat null
as a valid match if it's
explicitly passed as the filter value.
"ignore" | "include"
"ignore"
"include"
A function-based filter used for advanced filtering logic that cannot be represented using built-in filter types.
The function should return true
to keep a row or false
to filter it out.
params | FilterFnParams (docs) |
boolean
The parameters passed to a custom function filter.
Includes both the current row's data and the overall grid configuration.
The data object associated with the row. It may be null
if the row is loading or not yet available.
null | T
null
T
A reference to the LyteNyte Grid instance.
Type | Grid |
A functional filter definition. It provides ultimate flexibility for filtering scenarios that don't conform to basic models.
Should be used selectively and optimized for performance.
The filter function to evaluate for each row.
Type | FilterFn |
Type discriminator used to identify this as a function filter.
"\"func\""
Represents a set-based filter that checks whether a value is included in (or excluded from) a set of values.
Often referred to as a "Set Filter", this is a PRO-only feature in LyteNyte Grid and cannot be nested in combination filters.
Type discriminator used to identify this filter as an in
filter.
Ensures correct handling within the filter model.
"\"in\""
Specifies whether to include or exclude the values in the set. See FilterInOperator .
Type | FilterInOperator |
The set of allowed or disallowed values to filter against.
Values may include strings, numbers, or nulls. The operator determines how this set is interpreted.
Type | Set |
Represents a displayable filter option for use with the in
filter UI component.
Supports grouping and human-friendly labeling for raw filter values.
Grouping path to organize filter values into nested structures.
This is useful for tree-based UIs where items belong to categories (e.g., year > month > day).
No properties
A unique id for the in filter item.
string
The display label for the item in the UI. Should be human-readable even when the value itself is raw or technical.
string
The value to be matched in the in-filter set. Typically a string or number.
unknown
The valid operators for an in
filter.
"in"
: Tests for inclusion in the set."not_in"
: Tests for exclusion from the set."in" | "not_in"
"in"
"not_in"
Defines a filter for numeric columns.
Applies common comparison logic to include or exclude rows based on numerical values in a specified column.
Discriminant property used for type narrowing and filter dispatching. Identifies this object as a number-based filter.
"\"number\""
Operator to apply in the filter condition (e.g., greater_than
, equals
).
Determines how the row value is compared to the provided value
.
Optional behavior modifiers for the filter such as absolute value comparison and null handling.
These settings enhance precision and flexibility when filtering numerical data.
Target value for the filter.
This will be used as the right-hand operand when applying the operator to each row's value. May be null
if specifically filtering for nulls.
null | number
null
number
Logical operators available for number-based filtering.
These correspond to the traditional comparison operators, >, <=
, etc.
"greater_than" | "greater_than_or_equals" | "less_than" | "less_than_or_equals" | "equals" | "not_equals"
"greater_than"
"greater_than_or_equals"
"less_than"
"less_than_or_equals"
"equals"
"not_equals"
Optional configuration values for number filters. These options allow fine-tuning of filter behavior, especially in cases involving precision or null handling.
If set to true
, the filter will compare absolute values instead of signed numbers.
Useful for scenarios where magnitude is more relevant than direction (e.g., distance, deviation).
boolean
Floating-point precision buffer when evaluating comparisons.
For example, a comparison using epsilon = 0.0001
allows for minor rounding differences
when dealing with decimal values.
number
Controls how null
values are treated when applying the filter.
"ignore"
: Excludes rows where the value is null
"include"
: Retains rows with null
valuesNote: Actual behavior depends on the row data source. Properly implemented sources will
respect this setting, but others may not. Additionally, this setting may be ignored by some
filter operators. For instance, equality checks may treat null
as a valid match if it's
explicitly passed as the filter value.
"ignore" | "include"
"ignore"
"include"
Sensitivity mode for the quick search functionality.
"case-sensitive"
: Exact matches required."case-insensitive"
: Case differences are ignored."case-sensitive" | "case-insensitive"
"case-sensitive"
"case-insensitive"
Filter configuration for string-based column data.
Supports a wide range of operators such as exact match, substring containment, regex matching, and string length comparisons.
Type discriminant used internally to identify this as a string filter. Useful when filters are stored in a mixed array.
"\"string\""
The filtering operator (e.g., "contains", "equals", "length_greater_than").
Optional modifiers to control filter behavior including case sensitivity, whitespace, punctuation, and locale-sensitive matching.
The value to compare against.
May be:
string
: for most text comparisonsnumber
: for length-based operatorsnull
: when matching absence of valuenull | string | number
null
string
number
Collation configuration for locale-sensitive string comparisons.
Used to construct an Intl.Collator
instance, which enables proper handling of language and region-specific rules.
The locale string to apply during comparisons (e.g., "en", "de", "zh-CN"). This determines how values are interpreted for culturally appropriate sorting.
Type | Locale |
Specifies the sensitivity of character comparisons (e.g., case vs. accent differences).
See the Intl.Collator documentation for details on supported sensitivity levels.
"base" | "accent" | "case" | "variant"
"base"
"accent"
"case"
"variant"
List of operators available for string filtering.
These include comparison operators (e.g., "equals"), substring checks (e.g., "contains"), and
length-based checks (e.g., "length_less_than"). Some operators require a numeric value
(e.g., those dealing with string length).
"equals" | "not_equals" | "less_than" | "less_than_or_equals" | "greater_than" | "greater_than_or_equals" | "begins_with" | "not_begins_with" | "ends_with" | "not_ends_with" | "contains" | "not_contains" | "length" | "not_length" | "matches" | "length_less_than" | "length_less_than_or_equals" | "length_greater_than" | "length_greater_than_or_equals"
"equals"
"not_equals"
"less_than"
"less_than_or_equals"
"greater_than"
"greater_than_or_equals"
"begins_with"
"not_begins_with"
"ends_with"
"not_ends_with"
"contains"
"not_contains"
"length"
"not_length"
"matches"
"length_less_than"
"length_less_than_or_equals"
"length_greater_than"
"length_greater_than_or_equals"
Optional settings to modify the behavior of string filter evaluation.
These provide control over how string values are matched, such as case sensitivity, whitespace trimming, regular expression flags, and locale-based collation.
If true, string comparisons are case-insensitive.
Note: Some locales may implicitly perform case-insensitive comparisons depending on sensitivity
.
boolean
Collation options to apply locale-sensitive sorting and comparison behavior using Intl.Collator
.
If true, removes punctuation from strings before evaluating the comparison.
boolean
Controls how null
values are treated when applying the filter.
"ignore"
: Excludes rows where the value is null
"include"
: Retains rows with null
valuesNote: Actual behavior depends on the row data source. Properly implemented sources will
respect this setting, but others may not. Additionally, this setting may be ignored by some
filter operators. For instance, equality checks may treat null
as a valid match if it's
explicitly passed as the filter value.
"ignore" | "include"
"ignore"
"include"
Flags to apply when using the matches
operator (e.g., "i" for case-insensitive, "g" for global).
See the MDN RegExp flags guide for details.
string
If true, trims leading and trailing whitespace from both the value and target before comparing.
boolean
The supported locale identifiers for string filtering and collation.
Used to configure internationalized string comparison behavior.
"en-US" | "en-GB" | "en-CA" | "en-AU" | "en-IN" | "fr-FR" | "fr-CA" | "fr-BE" | "fr-CH" | "es-ES" | "es-MX" | "es-AR" | "es-CO" | "zh-CN" | "zh-TW" | "zh-HK" | "zh-Hant" | "zh-Hans" | "ar-SA" | "ar-EG" | "ar-AE" | "de-DE" | "de-AT" | "de-CH" | "ja-JP" | "ko-KR" | "hi-IN" | "pt-BR" | "pt-PT" | "ru-RU" | "uk-UA" | "pl-PL" | "it-IT" | "nl-NL" | "sv-SE" | "tr-TR" | "th-TH" | "vi-VN" | "he-IL" | "fa-IR" | "el-GR"
"en-US"
"en-GB"
"en-CA"
"en-AU"
"en-IN"
"fr-FR"
"fr-CA"
"fr-BE"
"fr-CH"
"es-ES"
"es-MX"
"es-AR"
"es-CO"
"zh-CN"
"zh-TW"
"zh-HK"
"zh-Hant"
"zh-Hans"
"ar-SA"
"ar-EG"
"ar-AE"
"de-DE"
"de-AT"
"de-CH"
"ja-JP"
"ko-KR"
"hi-IN"
"pt-BR"
"pt-PT"
"ru-RU"
"uk-UA"
"pl-PL"
"it-IT"
"nl-NL"
"sv-SE"
"tr-TR"
"th-TH"
"vi-VN"
"he-IL"
"fa-IR"
"el-GR"