| # Filters (ttadv9593m000) Use this session to define or edit filters. You can use the filters to: Display subsets of records in an overview session. Define a sort order. To display subsets of records, define one or more filter conditions. To specify a sort order for the filtered records, on the appropriate menu, select Define Sort Order. To remove a filter, on the appropriate menu, select Delete current filter. Note The filters only apply to the records displayed in the session from which you started the Filters (ttadv9593m000) session. Filter conditions A filter consists of one or more conditions that the displayed records fulfill. A condition has this format: Field Name - Operator - Value For example, in the Sales Orders (tdsls4100m000) session you can create a filter that consists of these conditions:
Field Name | Operator | Value
Sold-to Business Partner | is (exactly) | WR0000001
Order Amount | is more than | 10000
When you apply this filter, only records that fulfil both conditions are displayed in the session. That is: only orders of Sold-to Business Partner WR0000001, with an Order Amount greater than 10000, are displayed. Related topics Overview of filters To use filters Calling Session The session to which you can apply the filter. Filter Name The name that identifies the filter. Note When you apply the filter to the overview session, the filter name appears in the session's title bar. Publish Filter This field is only visible if you are logged on as a superuser. This field is hidden for normal users. If this check box is selected, and the filter is saved, the filter is available for all users. The published filter appears, for all users, on the Filter menu of the session to which the filter is linked. To open this menu, a user must select the Filter command on the session's View menu. If you clear this check box and save the filter, the filter is no longer public: the filter is only available for the user who created the filter. Field Name The field for which you want to specify a condition. When you apply the filter, the overview session only displays records where the contents of the selected field fulfil the corresponding filter condition. If you define more than one field for a filter, the conditions combine to form an AND relation. That is, when you apply the filter, the overview session only displays records that fulfil all your filter's conditions. Note You can only select fields that are displayed in the overview session and the details session. For technical reasons, some fields displayed in these sessions may not be available in the pull-down list. If a field in the pull-down list does not belong to the session's main table, the table name is displayed between brackets. Condition The operator to compare the contents of the selected field with the value specified in the Value field. Select the desired operator from the list. For details, refer to Operators used in filters. Value The value to which you want to compare the contents of the selected field. Note In the Match Case field, specify whether alphanumeric values are case sensitive. For enumerated fields (predefined values) and date fields, you can press Ctrl+B or click the zoom button to select a value. Lowercase characters have lower values than the equivalent uppercase characters. You can only use wildcard characters (.*) when you select contains, or doesn't contain in the Condition field. Related topics To use wildcard characters for filter values Examples of conditions in filters Match Case If this check box is selected, the condition is case sensitive. For alphanumeric values, the condition is only met if the record data contains exactly the same uppercase and lowercase characters as the text specified in the Value field. Set as Default If this option is selected (checked), the filter is applied automatically when you start the overview session. Delete current filter Removes the current filter and the corresponding conditions. Define Sort Order Starts the Define Sort Order (ttadv9193m001) session. Use this session to define a sort order for your filter. Apply Applies the filter to the overview session. If you close and restart the overview session the filter is not applied. Apply and Exit Applies the filter to the overview session, and closes the Filters (ttadv9593m000) session. If you close and restart the overview session, the filter is not applied. Rename Filter Changes the name of the filter. |