
If both criteria and formula are specified, then both the conditions are applied.Ĭlick Data Group Filter Criteria in the Departments data group: Fast formulas return values of Y or N to indicate if you must extract the record or not. If you can't specify the criteria as an expression, then you can place logic inside a fast formula which will not be as efficient. The filter criteria will be more efficient as it gets appended to the User Entity SQL at the time of execution. You can build criteria using the available database items, parameters and operators (conditional and logical). You can specify to filter data group as an expression or as fast formula, and you can choose one or both.

The extract data groups have been created successfully.Įxtract data group filters filter data extracted in the data group.

The root data group we will create will be the Departments data group.Ĭlick Advanced to search for the appropriate User Entity: The data group editor is automatically opened and this is where you create the Root Data Group: You make records with user entity information called attributes which are like table columns.

Data groups are defined with a user entity which is like a table.
