Expose task filters for runtime override

Filter values in Data Integration tasks are typically fixed. This works for repeatable jobs, but it requires you to edit the task whenever a value changes, such as updating a reporting period or company code.

By exposing a filter in Data Integration, you make it available for override at runtime. Users can then enter different values when running the job through Process Manager, without modifying the task. See Override Data Integration Filter Values in Process Manager.

Exposed and non-exposed filters can exist in the same task.

Setting Value behavior Available in Process Manager
Exposed off Always uses task value No
Exposed on Uses task value as default Yes

Expose filters on a task

  1. In the navigation panel, select Job Definitions.

  2. Expand the job that contains the task.

  3. Select the task to open the task editor.

  4. Scroll to the Filters section.

  5. Locate the filter you want to expose.

  6. Select Exposed for that filter.

  7. Click Save.

Repeat these steps for each additional filter you want to expose.

Set a default value

When a filter is exposed, the value entered in the Value field becomes the default used at runtime if no override is provided.

Always define a default value so the job can run successfully even if no override is entered in Process Manager.

How filter values are applied

When a job runs, the system determines the filter value in the following order, from highest to lowest priority:

  1. Runtime override provided in Process Manager

  2. Task value set in the task editor.

  3. Query default defined in Admin Setup.

The first available value in this order is used.

Troubleshooting

I don't see a Filters section in the task editor.

The query assigned to this task has no filters configured. Open Admin Setup, locate the query, and add the required filter parameters. After filters are added to the query, they will appear in the task editor.

I exposed a filter but it doesn't appear in the Data Integration process step.

If a filter is marked as Hide in Admin Setup, it will not appear in the task editor or at runtime — even if Exposed is selected. Clear the Hide setting on the filter in Admin Setup, then re-expose it on the task.

The runtime override is ignored and the task-level value is always used.

Confirm that the Exposed option is selected and saved on the task. If it is selected, check that the value entered at runtime matches the expected format shown in the tooltip. If the format is incorrect, the system may ignore the override and use the task value instead.

FAQ

Does exposing a filter on one task affect other tasks that use the same query?

No. The Exposed setting is applied per task. Changing it on one task does not affect other tasks.

How do I stop a filter from being exposed?

Clear the Exposed checkbox for the filter and click Save. The filter will no longer be available for runtime override and will use the value defined in the task.

Can I expose a filter and leave the Value field empty?

Yes, but this is not recommended.

If no runtime override is provided and the task value is empty, the system uses the query default from Admin Setup. If that is also empty, the filter may pass a blank value, which can lead to unexpected results or errors.