Entering Criteria in Filters

When you want to search for data, such as customer names, addresses, or product groups, you enter criteria. In search criteria you can use all the numbers and letters that you normally use in the specific field. In addition, you can use special symbols to further filter the results.

Searching using the Quick Filter

You can add filters to all pages by using the Quick Filter. The Quick Filter is enabled by choosing the magnifier icon in the top right corner of a page. This filtering type is used for a fast entry of criteria.

Important

The Quick Filter provides an easy access to filter data by entering plain text, but does also provide a lot of search criteria options. Depending on whether you enter plain text or text including symbols, the Quick Filter behaves differently.

  • If you enter plain text in the search criteria, the search criteria is interpreted as a case insensitive search that contains certain text.
  • If you enter text including symbols in the search criteria, the search criteria is interpreted exactly as you entered it, and the search is case sensitive.

Quick filter criteria

Search Criteria Interpreted as... Returns...
man @*man* All records that contain the text man and case insensitive.
se @*se* All records that contain the text se and case insensitive.
Man* Starts with Man and case sensitive. All records that start with the text Man.
'man' An exact text and case sensitive. All records that match man exactly.
@man* Starts with and case insensitive. All records that start with man.
@*man Ends with and case insensitive. All records that end with man.
Note

You cannot use a wildcard when filtering on enumeration fields, such as the Status field on sales orders. To enter a filter for this type of field, you can enter the numeric value as a filtering parameter. For example, in the Status field on a sales order that has the values Open, Released, Pending Approval, and Pending Prepayment, use the values 0, 1, 2, and 3 to filter for these options.

See Also

Working with Financials