User Tools

Site Tools


EXTERNAL FILTER

Guide Section: Excel Desktop Client | EASAP Tree: USER INTERFACE or OUTPUT branch > CASE VIEWER


EXTERNAL FILTER:

  • 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