Skip to main content

Report Condition Groups

What

Condition Groups within Reports and Smart Groups are a method of isolating specific logic for data queries.

When/Why

Condition groups are always used when you need to combine AND with OR logic within the same report.  If you are familiar with SQL, Condition Groups in FileWave are the equivalent of parentheses in SQL.  If you wanted a report that looked at all Windows or macOS devices, you wouldn't need a condition group, but as soon as we look for something like macOS or Windows AND Office is installed, then we need a condition group, because we need to combine AND with OR.

How

Following our example from above, watch below as we create the more complex smart group/report using condition groups:

Digging Deeper

Note that you'll find some quite complex examples of advanced condition groups in the Reports view under Sample Queries: