Skip to content

Value classifications

A value classification evaluates the content of a single column in a table.

For each row, the classification applies a predicate to the column value and produces a boolean result.

true
false

Value classifications are automatically re-evaluated whenever dependent data or time changes.

Evaluation model

A value classification evaluates a single column using a predicate.

row → column → predicate → boolean result

The evaluation always operates on:

  • a single row
  • a single column
  • a single predicate

Value classifications do not traverse relations.

Multiple value classifications may reference the same column.

Properties

Name

Human-readable name used in the interface.

Names do not need to be unique.

API name

Identifier used internally and in API usage.

Rules:

  • lowercase
  • allowed characters: a–z, 0–9, _
  • must be unique within the table

Table

The table where the classification is evaluated.

The classification is evaluated independently for each row in this table.

Column

The column whose value is evaluated.

Any column type may be used.

If the column is removed, any value classifications referencing it are removed as well.

Predicate

The condition applied to the column value.

Predicates determine how the column value is evaluated.

Available predicates are defined separately in the predicate reference.

Parameters

Some predicates require additional parameters.

Parameters are configured in the interface and validated according to the predicate requirements.

Different predicates expose different parameter inputs.

Use as filter

Controls whether the classification can be used as a filter in system filtering interfaces.

When enabled, the classification is available as a filter for data queries and views.

Disabling this option only affects filter availability.
The classification can still be used by rules, logical classifications, permissions, and other system logic.

Modification

After creation, only the following properties can be changed:

  • Name
  • API name

The following properties cannot be modified:

  • Table
  • Column
  • Predicate
  • Parameters

To change these properties, a new classification must be created.

Deletion

Value classifications can be deleted freely.

If a column is removed, all value classifications referencing that column are removed automatically.

Null handling

Column values may be null.

Predicates are responsible for determining how null values are interpreted during evaluation.

Understand the concept