Sidebar
EXTERNAL FILTER
Guide Section: Excel Desktop Client | EASAP Tree: USER INTERFACE or OUTPUT branch > CASE VIEWER
- is available for an Excel Desktop Client EASAP
- is a child of CASE VIEWER
- dynamically modifies the case records visible in its parent CASE VIEWER to be the case ID's returned from External Sql:
- may involve queries on arbitrary customer tables and thus is more flexible than FILTER
For example:
- External Sql: cases.id in (Select id from some_external_table where author == 'test')
 EXTERNAL FILTER |
|
|---|---|
| Essential Parameters: | |
| External SQL: | SQL to run to return case ID's to be displayed in the parent CASE VIEWER |