Interface TablePageConfigCalculatedColumn

interface TablePageConfigCalculatedColumn {
    alias: string;
    label?: string;
    position?: number;
    sqlExpression: string;
}

Properties

alias: string

Alias for the calculated column in SQL results and display This will be used as both the SQL alias and the property name in result objects

label?: string

Display name for the column

position?: number

Client-side index of the column in the table

sqlExpression: string

Raw SQL expression for the calculated column Use 'main' as the alias for the main table

'SELECT COUNT(*) FROM orders WHERE orders.user_id = main.id'