About quick filters

Quick filters allow you to create global filters based on data you select in a view. You can create quick filters based on a single selected value, or on multiple adjacent values. Quick filters are easier to create than filters you create with the Expression Builder, or enter manually, but they are also more limited. Like other types of filters, you can name and save quick filters for subsequent reuse. Quick filters auto-generate the syntax of the filter expression, which you can then modify as an easy way to create different or more complex filters.

You cannot use non-adjacent values in the initial application of a quick filter. Depending on the complexity of the filter, you may be able to rearrange fields in the view to make values adjacent. You can use non-adjacent values subsequently if you apply a second quick filter to the subset of data created by the first quick filter. If you need to use non-adjacent values in a single filter that operates on an unfiltered data set, and the values cannot be made adjacent by rearranging fields, you must enter the filter expression manually, or create it using the Expression Builder.

Note

Quick filtering by date, datetime, or time can produce invalid results if you have specified a date or time display format that does not display all the available source data – for example, if you specify the format hh:mm for times that have hour, minute, and seconds data.

For more information about date and time display formats, see Options dialog box: Date and Time tab.

You can use quick filters with any data type. The specific options available within a quick filter depend on the data you select:

Data selected

Quick filter options available

a single character or numeric value

  • Equal

  • Not Equal

  • Greater Than

  • Greater Than Or Equal To

  • Less Than

  • Less Than Or Equal To

a single date value

  • On

  • Not On

  • After

  • On or After

  • Before

  • On or Before

a single datetime or time value

  • At

  • Not At

  • After

  • At or After

  • Before

  • At or Before

a single logical value, or multiple adjacent values in the same record

  • Equal

  • Not Equal

multiple adjacent character or numeric values in the same column

  • Equal

  • Not Equal

  • Between

  • Not Between

multiple adjacent date values in the same column

  • On

  • Not On

  • Between

  • Not Between

multiple adjacent datetime or time values in the same column

  • At

  • Not At

  • Between

  • Not Between

multiple adjacent fields in the same record

  • Equal

  • Not Equal

a block of values spanning two or more records and two or more columns

  • Equal (not shown)

Related concepts
Using filters
About global filters (view filters)
About local filters (command filters)
About data filters
Related tasks
Applying quick filters to views


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback