Reports - Writing Custom Column Expressions

Table Names

You can use %tableAlias%  to reference the current table. Most of the report code automatically aliases the tables as matter_5  or person_22  depending on how they are added to the report. This alias will allow you to reference the current table the field is created on instead of needing to know the name of the table directly.

Parentheses

We recommend wrapping whatever expression you create in a set of parentheses to make sure it is evaluated on its own.

Filtering

Some Expressions will now allow you to filter on them. Others may allow you to filter on them. If the formula involves any aggregation, you may want to use the Advanced -> Apply after Aggregate option on the filter.

SQL Language

LegalServer uses Postgres 14.