A filter row is a simpler alternative to filter dropdowns. In a Table
View, it is displayed directly under column headers. When initially
drawn (or not focused and no filtering is applied), it displays a text
describing its functionality:

A filter row is separated from other rows by a horizontal bar – the
filter row's separator. You can filter results by any field, which is
currently located in the View.

A filter row provides three ways of filtering:

• the filter row's in-place editors add an auto-complete feature. When
  you start typing characters, an in-place editor automatically
  completes with the field value containing similar starting
  characters.  Pressing the Enter key updates the View with the
  filtered data.
• the View is dynamically updated with the filtered data every time
  you continue typing in the in-place editor.
• the View is updated with the filtered data after a delay, allowing
  you to make a more complete entry within the in-place editor. This
  improves filtering performance when handling large databases.

If a field contains string data, a filter row uses a LIKE operator.

You can specify wildcard operators for a LIKE-match. The default
operators are a percent sign (%) for a substring comparison, and an
underscore (_) for a single character comparison. To change the
comparison behaviour, you can substitute the above operators with the
other wildcards.

Tip

By default, filtering is case insensitive.