Export (0) Print
Expand All

Filter Settings (Object Explorer and Utility Explorer)

Use this dialog box to specify a filter. A filter allows you to configure Object Explorer and Utility Explorer to display only items that meet specific criteria. For example, you can use a filter to show only jobs with names that contain the word "Maintenance." The header for the Filter Settings dialog box contains the name of the server, and it may contain the name of the database.

Property

Displays the property to filter on.

Operator

Select the way that the filter applies the value to the property. There are the following options:

  • Equals

    The filter shows items where the property and the value are an exact match.

  • Contains

    The filter shows items where the property contains the value. The property may contain other text.

  • Does not contain

    The filter shows items that where the property does not contain the value.

  • Less than

    Available for dates, this filter shows items whose date is before the value provided.

  • Less than or equal

    Available for dates, this filter shows items whose date contains or is before the value provided.

  • Greater than

    Available for dates, this filter shows items whose date is after the value provided.

  • Greater than or equal

    Available for dates, this filter shows items whose date contains or is after the value provided.

  • Between

    Available for dates, this filter shows items whose date is between two dates provided. Select Between and press TAB to add another row allowing entry of the second date.

  • Not between

    Available for dates, this filter shows items whose date is before or after two dates provided. Select Not Between and tab out of the Operator column to add another row allowing entry of the second date.

Value

Type the value to compare to the property. For dates, click the down arrow to show a calendar for selecting the date.

Clear Filter

Removes all current filter settings.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft