|
|
Filter by Patterns Actions
Filter by Patterns actions filter the contents of a Table parameter or dataset, retaining or discarding rows that match one or more specified patterns. The results are stored in a Table dataset.
| Action Property | Description |
|---|---|
| Keep Matches | A Boolean parameter which determines whether matching rows from the Source table will be retained or discarded. If this parameter is set to ‘true’, rows that match any of the specified patterns are stored in the Result table. If this parameter is set to ‘false’, rows that do not match any of the specified patterns are stored in the Result table. |
| Patterns | A Table parameter containing the patterns to be matched against the Source table. |
| Result | A Table dataset which stores either the matching or non-matching rows from the Source table. |
| Source | A Table parameter or dataset containing the rows to be filtered. |
| Source Name Column | A String parameter set to the name of a column from the Source table which contains the names of the objects to be filtered. If this action property is not set, NAME is used as the default value. |
| Source Type Column | A String parameter containing the name of a column from the Source table which contains the types of the objects to be filtered. If this action property is not set, TYPE is used as the default value. |
The ‘Patterns’ table should contain the following columns:
| Column | Description |
|---|---|
| TYPE | A value to be matched against the Source Type column. The value ALL matches against all entries in the Source Type column. |
| SapQuery | This value is not used. |
| Like | This value is not used. |
| RegEx | A Regular Expression to be matched against the Source Name column. |
| IorE (optional) | If this column is set to ‘I’, values from the Source Name column which match the Regular Expression are included in the matching set. If this column is set to ‘E’, values which match the Regular Expression are excluded. Each value is matched against the ‘Exclude’ patterns first, and if a match is found the value is not added to the matching set. Otherwise, the value is matched against the ‘Include’ patterns, and added to the matching set if a match is found. If the IorE column is missing or blank, the default is to include matching names. |
Each row in the Patterns table represents a single pattern. A row from the Source table is considered a ‘match’ if it matches at least one of the patterns.
Example:
To examine the details for a Filter by Patterns action, double-click the dataset node, or select ‘View Details’ from the node’s context menu. The Details screen displays the number of records in the Source and Result tables, and the time taken for the action to complete.