Dynamically export relevant records

When creating a DMI task, you can use filters to dynamically export only the relevant records.

The following dynamic filters are available:

• Additional Filter
• Placeholder Filter

In addition to static values, these filters accept the following dynamic variables:

• $FICMISDATE$
• $BATCHRUNID$

Set the filters in the following format:

DATA_TABLE.<AS_OF_DATE> = $FICMISDATE$ AND DATA_TABLE.<EXECUTION_ID> = $BATCHRUNID$

Example: FSI_ALM_CASHFLOW_OUTPUT_HIST.AS_OF_DATE = $FICMISDATE$ AND FSI_ALM_CASHFLOW_OUTPUT_HIST.EXECUTION_ID = $BATCHRUNID$

Date format supplied by scheduler for $FICMISDATE$ is YYYY-MM-DD.