Operator Guide

Back Next

Basic Expression Properties

When you define a filter condition with a basic expression for a subscription, the

Filter

page shows the following properties:

Select Table: Select the table to which to apply the filter.
Select Column: Select the column to filter.
You denote columns as filter accelerators at the topic level.
Data Integration Hub
indexes the columns that are denoted as filter accelerators in the
Data Integration Hub
publication repository and uses them to accelerate data retrieval.
Select Operator: Select the filter operator.
The available operators depend on the type of content in the column.
Enter Value: When this field is enabled, select or enter a value for the operator.
Values of string operators can contain up to 90 digits. Values of numeric operators can contain up to 15 digits.