Search Criteria folder - Personalize View

The Search Criteria folder contains the following elements:

• Show Only Fields Containing - this text box allows you to filter the information displayed in the Available Fields list box. The Available Fields list box has the potential to display hundreds of fields. Enter the text you are looking for in the 'Show Only Fields Containing' text box and the Available Fields list box displays only those fields (and associated table names, if applicable) containing the information entered. For example, if you are personalizing the Customer Master and you enter the word 'terms', all of the fields and table names with the word 'terms' display in the 'Available Fields' list box:

  
  

• Exclude Related Fields - select this check box to display the fields that are assigned to the base table for the selected view in the Available Fields list box.

  Tip: You can identify the name of base tables for views, created by Tecsys, by hovering over the title of the view on the iTopia menu. Following the example below, if you hover over Order Header(OE45) the description 'Order Header(OE45) (ibis_oeoo.1.order_ header_oe45)' displays. The base table used for this view is ibis_oeoo.1.

  

• Available Fields - the Available Fields list box includes the criteria data elements that are available for the view. It includes the data elements from the base table and other tables that relate to the current view. Fields that belong to the base table do not display the English Description of the table name, however fields from related tables include the related English Description table name in brackets beside the field name.
  • Once a field is selected from the Available Fields list box, it is removed from this list.

  You can add single fields to the Show These Fields in this Order list box by the following methods:

  1. Double click on the selected field.

  2. Select the field and click the Add icon .

  You can also move multiple fields to the Show These Fields in this Order list box by either of the following methods:

  1. You can select groups of fields by holding down your Shift key and selecting a first and last field from the list and then clicking on the Add icon. All fields between the first and last field selected are moved to the Show These Fields list box.

  2. You can select multiple individual fields by holding down the Ctrl key and using your mouse to select fields (not sequential) and then clicking the Add icon. These individual fields are all moved to the Show These Fields list box.

  Note: To place the fields in a particular spot in the Show These Fields list box, highlight the field in the Show These Fields list box that you want the selected field(s) to follow, and when you add the fields, they will be inserted after this highlighted field. Otherwise, the fields being added are added to the bottom of the list of fields in the Show These Fields list box.

• Show These Fields In This Order - only fields in this list box will appear in the Search Criteria section of the view, in the order in which they are displayed here. You can also re-order these fields:
  • To Move Up a single field, highlight the field and click Move Up to move this field up one level. You can also move up a group of fields by using the Shift key to select a group of consecutive fields or the Ctrl key to select several individual fields and then click Move Up.

  • To Move Down a single field, highlight the field and click Move Down to move this field down one level. You can also move down a group of fields by using the Shift key to select a group of consecutive fields or the Ctrl key to select several individual fields and then click Move Down.

  • To Remove a field, highlight the field and click Remove to move this field from the 'Show These Fields in This Order' list box back into the 'Available Fields' list box, or double click on the field name and it is automatically returned to the other list box.

• Default Value For (field name displays) - with the field name in the 'Show These Fields in This Order' list box highlighted, you can optionally assign a default value to the field which will help execute your search even quicker, or to display the results you seek most often. For example, you can set the 'Company' field to default to a '10'; every time you run this report, the Company field will default to Company 10.
  • Note: The Default Value field is not a case-sensitive field. Key fields are always forced to UPPER CASE. If the chosen field includes a group of predefined values the look up icon displays to the right of this field allowing you the option of selecting one of those values as the default value. If the field represents a date, then the Calendar icon becomes available.

  • You can also enter wild cards as part of the Default Value. For example, if you are personalizing the Product Master (IM13) view and you always want to display all products that begin with BAS you can enter BAS* and all product that start with BAS will automatically display when a search is initiated.

  Here is an illustration of the Default Value field:

  

• Show At Launch - defaults to selected (checked). When the check box is selected, the field highlighted in the 'Show These Fields in This Order' list box displays in the search criteria. When this check box is deselected, the field is hidden in the search criteria section of the view.
  • When this check box is deselected for one or more fields on the Search Criteria folder, a More link displays to the right of the Search Criteria label on the Search Results page. In the following example, we have deselected the 'Show at Launch' check box for the Customer Code and Warehouse fields:

• Once you select the 'more' link the Customer Code field displays in the search criteria and a Less link displays to the right of the Search Criteria label:

For information on the functionality of each button on the Search Criteria folder in the Personalization section, click here.