The Search Criteria area displays the fields for filtering your search. If stored search criteria exist, you can select one by name from the drop-down list at the top of the search criteria. This sets up the filter criteria to produce preconfigured results.
Otherwise, the search fields display with a default configuration. You can refine the search using combinations of filters and wild cards (*). Click the + and X buttons to add and remove search filters.
Initially, one search condition displays. Choose the field that you want to search from the drop-down list.
1 Choose a search operator from the drop-down list. The search operators include the following:
• not equals
• starts at (the default)
• greater than
• less than
• is null
• is not null
2 Enter a value in the search box or select a value from the associated lookup.
For character fields, the asterisk (*) is a wildcard character, matching any number of characters when the search operator is equals or contains. If you want to search for the * character, precede with a backslash ( \* ). If you want to search for the backslash character, use two backslashes (\\).
You can enter a comma-separated list of values in the search field for browses. When the search conditions include the equals or not equals operators and the search is against values of the string data type, the search query will perform a logical OR on the results.
When configuring a browse, you can enter variables in search values. For example, when browsing for sales order bills, you can select SessionID, UserID, Entity ID, or Domain from the Search Variable drop-down list. Different components display different search variables in the drop-down list. The Toggle Search Variable Mode button toggles this option.
You can also use database fields of the same type as filters. For example, you can filter a browse to retrieve records for which Sold-To equals Ship-to, Date Due is greater than Date Shipped, or Quantity Ordered is greater than Quantity Shipped. The Toggle Search Variable Mode button also toggles this option.
Toggle Search Variable Mode
Note: When searching according to a range of values, be aware that the string comparison method used by the .NET environment can produce a different sort order than the Progress database sort order in certain situations. For instance, .NET treats the dash (-) character as greater than the zero (0) character but the Progress database does not.
3 Click Search.
4 To refine your search further, click the plus (+) icon to add another search row. You can add as many rows as needed, each with different search values and operators. If you choose the range search operator, the second search box is enabled for the ending value of the range. When you specify several criteria, note the following:
• Multiple criteria for the same field are treated as a logical OR condition.
• Multiple criteria for different fields are treated as a logical AND condition. The not equals and not null criteria are always treated as a logical AND condition, even with other criteria on the same field.
5 To remove a search criteria row, click on the delete (x) icon.
You can use the Manage Filter Fields option (see Manage Filter Fields
) to display more fields or other fields on component-based browses. Adding and removing Filter Fields with + and X or using the Manage Filter fields menu option provides the same result. However, with the Manage Filter fields option, you can also give the fields persistent initial values if you save the changes in the Stored Search menu.
Using Manage Filter Fields, you can also change the order of the filter fields by right-clicking and choosing Move Up, Move Top, Move Down, or Move Bottom. You can also select a field and move it by pressing the Alt key and then pressing the Arrow Up or Arrow Down key.