A filter editor dialog is convenient to use when you have a big table and want to view only specific data in specific columns. You can decide which data to show in a table, for example, customers only from a specific country, or products with prices higher than $100.

To open a filter editor dialog, click the filter icon in the upper-right corner of any table. You can also access the filter editor dialog from the Virtual Table settings and Query Editor windows.

Fill in the following data:

  • FieldName: Select the field to which you are going to apply the filter, for example, UnitPrice.
  • Operation: Select the operation that the system will use to fetch your data, for example, GreaterThan.
  • Value: Type the value by which you are going to filter, for example, 100.
  • And/Or: Make a selection in this field if you are going to add more rows.

When ready, click Set Filter.

Filtering Operations

When setting up a filter in Worksheet Systems, you can choose one of the following filtering operations:

OperationExplanationExample
EqualDisplays the column content with one value that is equal to the specified value.If you want to display only customers from the UK, then specify the following parameters:

  • FieldName: Country
  • Operation: Equal
  • Value: UK
NotEqualExcludes the column content with one value that is not equal to the specified value.If you want to display all customers EXCEPT the ones from the UK, then specify the following parameters:

  • FieldName: Country
  • Operation: NotEqual
  • Value: UK
InDisplays the column content with several values that are equal to the specified values.If you want to display only customers from the UK and Germany, then specify the following parameters:

  • FieldName: Country
  • Operation: In
  • Value: UK, Germany
NotInExcludes the column content with several values that are not equal to the specified values.If you want to display all customers EXCEPT the ones from the UK and Germany, then specify the following parameters:

  • FieldName: Country
  • Operation: NotIn
  • Value: UK, Germany
LikeDisplays the column content that contains a specific character (e.g. alphabetic letter) or several characters (e.g. a combination of alphabetic letters). If you want to display only customers from the city starting with the letter “B”, then specify the following parameters:

  • FieldName: City
  • Operation: Like
  • Value: b%

If you want to display only customers from the city CONTAINING the letter “B”, then specify the following parameters:

  • FieldName: City
  • Operation: Like
  • Value: %b%

You can use any wildcard characters to customize the filter results. For more information about the wildcards, see this article.

NotLikeExcludes the column content that contains a specific character (e.g. alphabetic letter) or several characters (e.g. a combination of alphabetic letters). If you want to display all customers EXCEPT the ones from the city starting with the letter “B”, then specify the following parameters:

  • FieldName: City
  • Operation: NotLike
  • Value: b%

If you want to display all customers EXCEPT the ones from the city CONTAINING the letter “B”, then specify the following parameters:

  • FieldName: City
  • Operation: NotLike
  • Value: %b%

You can use any wildcard characters to customize the filter results. For more information about the wildcards, see this article.

LessThanDisplays the content of a numeric field that is less than the specified value.If you want to display products with prices lower than $100, then specify the following parameters:

  • FieldName: UnitPrice
  • Operation: LessThan
  • Value: 100
GreaterThanDisplays the content of a numeric field that is greater than the specified value.If you want to display products with prices higher than $100, then specify the following parameters:

  • FieldName: UnitPrice
  • Operation: GreaterThan
  • Value: 100
GreaterThanOrEqualDisplays the content of a numeric field that is greater than or equal to the specified value. If you want to display products with prices either higher than $100 or equal to $100, then specify the following parameters:

  • FieldName: UnitPrice
  • Operation: GreaterThanOrEqual
  • Value: 100
IsBlankDisplays the records where the specified fields have no data.
If you want to check whether a city is missing for some customer in a data table, then specify the following parameters:

  • FieldName: City
  • Operation: IsBlank
IsNotBlankDisplays the records where the specified fields are filled with data.If a region record is filled only for a few customers, you can display only those customer records that contain the region record. For this, specify the following parameters:

  • FieldName: Region
  • Operation: IsNotBlank