Change the Path Filtering

If you want to change the filter settings for an existing path, the steps are mostly the same as those for creating the filtering for a new path.

From the left navigation pane of the Distribution Service home page, click Distribution Path.

For the specific distribution path, click Action. From the drop-down list, click Change Filtering.

Rule Cofiguration Task

Add paths

Rule Cofiguration	Task
Add paths	If you enable filtering by selecting it from the toggle button and click Add Rule , you’ll see the Rule Definition dialog box. `Rule Name` `Rule Action`: Select either Exclude or Include `Filter Type`: Select from the following list of options: Object Type: Select from three object types: `DML`, `DDL`, and `Procedure` `Object Names`: Select this option to provide an existing object name. A 3–part naming convention depends on whether you are using CDB. With CDB, you need to use a 3–part naming convention, otherwise a 2–part convention is mandatory. 3–part convention includes container, `schema`, `object`. 2–part convention includes `schema`, `object name`. `Procedure Feature Name`: Select this option to filter, based on existing procedure feature name. `Column Based`: If you select this option, you are presented with the option to enter the table and column name to which the rule applies. You can filter out using column value with `LT`, `GT`, `EQ`, `LE`, `GE`, `NE` conditions. You can also specify if you want to have before image or after image in filtered data. `Tag`: Select this option to set the filter based on tags. `Chunk ID`: Displays the configuration details of database shards, however, the details can’t be edited. `Negate`: Select this check box if you need to negate any existing rule. You can also see the JSON script for the rule by clicking the JSON tab.

If you enable filtering by selecting it from the toggle button and click Add Rule , you’ll see the Rule Definition dialog box.

Rule Name
Rule Action: Select either Exclude or Include
Filter Type: Select from the following list of options:
- Object Type: Select from three object types: DML, DDL, and Procedure
- Object Names: Select this option to provide an existing object name. A 3–part naming convention depends on whether you are using CDB. With CDB, you need to use a 3–part naming convention, otherwise a 2–part convention is mandatory. 3–part convention includes container, schema, object. 2–part convention includes schema, object name.
- Procedure Feature Name: Select this option to filter, based on existing procedure feature name.
- Column Based: If you select this option, you are presented with the option to enter the table and column name to which the rule applies. You can filter out using column value with LT, GT, EQ, LE, GE, NE conditions. You can also specify if you want to have before image or after image in filtered data.
- Tag: Select this option to set the filter based on tags.
- Chunk ID: Displays the configuration details of database shards, however, the details can’t be edited.
Negate: Select this check box if you need to negate any existing rule.

You can also see the JSON script for the rule by clicking the JSON tab.

After you add a rule, it is listed in Inclusion Rules. You can delete rules or edit them. When you edit a rule, you have the same options as adding a rule with the following added filters:

Options	Description
OR AND	Select one logical operator.
Chunk ID	Edit or delete the database shard settings if sharding is used.
Object Type:	Edit or delete the type of object for the rule.