Creating and running an Extract: Filter Criteria
Use the Business Intelligence Exchange (BIX) Filter Criteria tab on the BIX ruleform to select filter conditions for properties of the primary class and on the clipboard at runtime.
- In Criteria, specify the following filter
information:
Criteria filter Description Use last updated time as start The default symbolic reference filter Last Extraction Time, pxUpdateDateTime, functionally replaces the pxCommitDateTime property to enable incremental extractions. It is recommended to clear Use last updated time as start and rely on the default symbolic reference pxUpdateDateTime in the filter criteria.Select for incremental extractions in order to limit extracted data to properties that contain an updated pxCommitDateTime instance when compared to the last extraction. You must configure incremental extractions using classes that contain the property pxCommitDateTime.Skip standard filters Select to exclude the primary key column ( pzInskey /pxObjClass) from the filter during extraction. For more information about the database table primary key, see Database table primary key (handle).Skip standard order by clause Select to exclude default sorting based on the primary key column ( pzInskey /pxObjClass) for the extraction. - In Filter conditions to apply, define the filter criteria by referencing the labels of the rows below and applying the SQL operators AND, OR, and parentheses. For example, if there are four filters labeled A, B, C, and D, you can enter the following logical expression: "(A OR B OR C) AND D".
- Optional: The default field pxUpdateDateTime enables incremental
extractions in order to limit extracted data to properties that contain an
updated pxUpdateDateTime instance when compared to the last
extraction.
Delete this field to run use manual extractions.
- In the filter table, click +Add filter add a row and
enter the appropriate filter information:
Field Description Label Enter an alphanumeric label for the filter. Do not include spaces in the label. Field Enter a property from the referenced class. Properties must begin with a period. When entering a property, a list of potential property matches appears. Select Best Bet to see the closest matching-property entered string. Select All Matches to see matching properties that contain the string you entered. Example: .pxObjClass
Calculation Builder (icon) Click the icon and select an available SQL function call, literal value, or property name. For details, see The Calculation Builder. Operator Select a logical operator for the comparison condition, such as Is equal or Starts with. Value Enter a value for a property that exists in the class or that you created in the Parameters or Pages & Classes tab to run against the field and operator. When you enter a property value, a list of potential value matches appears. Select Best Bet to see the closest matching property matches to the entered value. Select All Matches to see matching values for the alphanumeric value that you entered. Values to run against the operator include the following:
Example Values A parameter defined in the Parameters A page & class defined in the Pages & Classes A constant type. For more information, see Constants in expressions A symbolic date relative to the time of extraction, such as Yesterday A calculation. Click the Calculation Builder Use null if empty Select to replace empty Value fields with a nullvalue to ensure extract files do not contain empty values.Ignore Case Select to ignore lowercase and uppercase in the Field and Value of the filter. - Click Save to apply this filter criteria.
- Return to Creating and running an Extract rule to continue creating an Extract rule.
Previous topic Creating and running an Extract rule Next topic More about Extract rules