Filters: (Optional) Create Filters for Data Elements

You can set up filters to display only those data elements that meet the filter criteria in the data source being created. For example, you can create a filter to display only those records with an Open Issue Status.

Note:

This step is optional. You can select Skip to move to Preview: Created Data Source of the guided process.

To create a filter on a data element:

1. Select Add Condition (+) in the Filters step of the Data Source Creation guided process.
2. From the Condition list, select one of the following:
   • All: Select this option to specify an AND condition to ensure all filter conditions are met for the filter being defined.
   • Any: Select this option to specify an OR condition to ensure any one condition is met for the filter being defined.
3. For each condition, select a Data Element, Condition, and Value as follows:
   1. From the Data Element list, select a data element that was added to this data source in Data Elements: Select Data Elements for the Data Source. For example, select Creation Date from the list.
   2. In the Condition field, enter a condition or select a condition from the Condition list that the data element (selected in the previous step) must satisfy. For example, Creation Date, selected in the previous step, is of Date data type.

      For more information on the list of conditions supported for each data type, see Supported Conditions for Data Types.

   3. In the Value field, enter a value or a range of values the condition must satisfy.

      Note:

      The format of the Value fields depends on the type of values that can be entered or selected. It can be a text field, a list, or a combination of text and list fields.

4. (Optional) Select any of the following actions:
   • Add Condition (+): Select to specify more than one condition for the filter. Repeat step 3.
   • Remove Conditions (): Select to delete each condition.
5. From the Save menu, select any of the following options to save the defined filters:
   • Save: Select to save the selected information displayed in the Data Elements step.
   • Save and Close: Select to return to the Data Sources log.
6. Select Continue to proceed to Preview: Created Data Source of the guided process.

   Note:

   • You can click Cancel in any step of the guided process to discontinue and return to the Data Sources log.
   • It is recommended to click Save in each step to avoid losing any unsaved information or selections made in that step.
   • You may receive an error message during Data Structure setup when you enter a valid Data Structure and a valid Data View. You can disregard the error and proceed with editing and saving the Data Structure.
   • If a data source is removed from a BP design or data view, update the data source before you create, view, or update the content based on that data source.
   • The file size of blank files display as zero (0), but in the database it is a null. Therefore, filtering on fields such as File Size won't retrieve any records as the database does not store the zero value.