Filtering by property values

You can configure either dynamic or static property values to be available for filtering data items from a particular data source. If you select the data source in the Filter window, the property values are available as more filter criteria.

About this task

In the data sources tool, on the Key & Full Properties tab, you can select a property and choose to configure either dynamic property values, or static property values. Dynamic property values are received at run time. Static property values are fixed at the allowed values that you configure for the property on the Key & Full Properties tab. You can configure dynamic properties to allow users to search for dynamic property values by entering free text values in the More Filters window, instead of choosing from a list of dynamic, enumerated property values.

Procedure

  • To enable a list of dynamic, enumerated property values to be displayed in the More Filters window, ensure that the following requirements are met:
    1. If the property is not a minimal property, set the value of the Key property field to Yes. The property must be either a minimal property, or a key property.
    2. Ensure that the property type is VARCHAR, INTEGER, BIGINT, DECIMAL, or DOUBLE.
    3. Set the value of the Filter by field to Enumerated values.
  • To allow users to search for dynamic property values by entering free text values in the More Filters window, ensure that the following requirements are met:
    1. If the property is not a minimal property, set the value of the Key property field to Yes. The property must be either a minimal property, or a key property.
    2. Ensure that the property type is VARCHAR, INTEGER, BIGINT, DECIMAL, or DOUBLE.
    3. Set the value of the Filter by field to Free text search values.
  • To enable a list of static property values to be displayed in the More Filters window, ensure that the following requirements are met:
    1. If the property is not a minimal property, set the value of the Key property field to Yes. The property must be either a minimal property, or a key property.
    2. Ensure that the property type is VARCHAR, INTEGER, BIGINT, DECIMAL, or DOUBLE.
    3. Set the value of the Filter by field to Allowed values.
    4. In the Allowed values field, enter a comma-separated list of static property values that will be displayed in the filter's More Filters window. Spaces are not removed from property values.

What to do next

When you select the data source in the Filter window, the More link is displayed if more filter criteria are available through either dynamic values, or static values. Click More to display the More Filters window. In the More Filters window, you can create filtering expressions by applying comparison operators to property values. For each property that you want to filter on, depending on the configuration of the data source, either select one or more property values from the list of property values, or enter a single property value into the text field.
  • If you enter a filtering expression based on only one property, data items in which that property's value match the filtering expression are displayed.
  • If you enter filtering expressions based on multiple properties then, to be displayed in the filtered results, a data item must match all expressions for each property.
  • If you do not enter filtering expressions for any property, none of the more filter criteria are applied. Data items do not need to match any of the more filter criteria to be displayed.