Filter Criteria Fields

The criteria available for filtering a profile view depend on the table you are using to filter the profile. However, the filtering operation is similar, regardless of the data. Use the information in the following sections to help you understand how to select and define information to filter a profile view.

New Criteria

The New Criteria section allows you to filter the data in the selected table that will be included in the filter output.

Field/Button	Description
Field Name	The available field names are populated based on the table you choose to filter. Commonly filtered fields appear as selectable buttons below the field list, or you can click the drop-down list to display all fields in the table.
Operator	The Operator field describes how to filter the Field Name for the filter. Selections in the Operator list vary based on the data type of the selected field.
Value	The Value field is used in conjunction with the Operator to filter the data in the selected field.
Add/Update	The Add button adds the field/operator/value combination to the filter criteria and displays the filter in the Criteria section at the bottom of the page. This button changes to Update when you edit an existing criteria line.
Clear	The Clear button clears all of the selections in the New Criteria section of the page.

Criteria

The Criteria section displays the criteria lines that have been added to the filter. This section will be blank until you add a criteria line to the filter.

Field/Button	Description	Notes
Edit	Select a line in the criteria section and click the Edit button to change the Field Name, Operator, and Value for the criteria. The selected criteria appear in the New Criteria section for editing. Click the Update button to save any changes.	This button is disabled until you add criteria to the filter.
Cut	Use the Cut button with the Paste button to move a criteria line up or down in the Criteria list. You can also Cut a criteria line to delete it.	See Criteria Organization for information about how the order of criteria can affect the filter results.
Copy	Use the Copy button to copy a criteria line. You can then paste the line in a new location to be used as is or edited as needed.
Paste	Use the Paste button to paste a copied criteria line.
Group	Click the Group to indicate that filter results should have a secondary grouping by the criteria immediately following the Group line in the Criteria.	The Group function in filters is similar to the grouping functions in the Millennium Reporter. See Reporting Groups for more information.