EXTERNAL FILTER may be used in an Excel Desktop Client EASAP.

EXTERNAL FILTER is a Child of CASE VIEWER.

EXTERNAL FILTER dynamically modifies the case records visible in its Parent CASE VIEWER according the case id's return from the SQL in External Sql:

EXTERNAL FILTER queries may involve tables other than cases and thus has a wider, more general scope than FILTER.

For example,

• External Sql: cases.id in (Select id from some_external_table where author == 'test')