FILTER - j5 - 28.0 - Administration & Configuration - Hexagon

j5 IndustraForm Designer Reference

Language
English
Product
j5
Search by Category
Administration & Configuration
j5 Version
2019

Filters incoming table data by evaluating a SQL boolean expression over the data.

= FILTER(table, filter_expression[, parameter, ...])

table - The table data to filter, or FilterInput if this is being used as a context filter.

filter_expression - SQL where clause expression to evaluate (only reference one column, use ? for parameters).

parameter - A parameter to include in the SQL clause (one for each ? in the clause).