← Back to Stormify Documentation

addSqlFacet

fun addSqlFacet(expression: String, type: Facet.Type = Facet.Type.TEXT): Facet

Adds a raw/custom column backed by an arbitrary SQL expression.

Return

The created column

Parameters

expression

The SQL expression (e.g., "SUM(amount)", "COALESCE(a, b)")

type

The column type, which determines how filter values are interpreted. Defaults to Facet.Type.TEXT.


fun addSqlFacet(expression: String, type: Facet.Type, converter: Converter): Facet

Adds a raw/custom column with a custom Converter. The converter receives the column expression and the user's filter value, and returns a SQL fragment while staging bind parameters via SqlArgsCollector.