Jillene Reeg, Sr. Development Analyst
Customizing the JD Edwards Enterprise One Auto Suggest Feature
Auto Suggest is a user interface feature which allows users to search for and filter text on Auto Suggest-enabled fields. Auto Suggest queries pre-defined tables and displays records that match text you type into a field. As you type text into a text field, one or more possible matches for the text are found and immediately presented to you in a grid beneath or beside the field. These immediate results enable you to stop typing the entire word or phrase, and instead, choose a record from the list that displays.
Auto Suggest searches for data in multiple tables and returns 10 matching records per page. The feature does not require you to remember the code or number for the field. Instead, you can type the name or description of the field and the system will search the name or description that begins with what you typed. Auto Suggest is case sensitive. If the descriptions in your database are lower case and you’re typing mixed case or upper case, there may be no results returned. Auto Suggest differs from Visual Assist in that it can query multiple tables, and requires fewer mouse clicks.
JD Edwards EnterpriseOne Tools Documentation documents the proper setup and enabling of Auto Suggest. This feature is available as of the 9.1 release. Auto Suggest is customizable for a customer’s specific needs. There are two ways to customize the Auto Suggest feature.
Modify an existing Auto Suggest Feature
Add a custom Auto Suggest Feature
Modify an Auto Suggest Feature
To modify an Auto Suggest Feature:
Launch P958973 Runtime Feature Definitions
2. Select a grid row to open the Runtime Feature Revisions form
The following elements can be modified in this form for an Auto Suggest feature:
Data Item - Data dictionary item to which the Auto Suggest feature is applied
No Auto Suggest
This option will allow you to turn off Auto Suggest and enable the use of the Auto Suggest feature by system code as well as excluding applications within a system code
Business View
Defines the set of data that Auto Suggest will use for its query
Language Business View
The language business view will provide translated descriptions for the data item
Number of Characters Required
Sets the number of characters the user must enter for Auto Suggest feature to be triggered
Hot Key Required
Determines if Auto Suggest will automatically display once the required number of characters threshold is met. If this is turned off, the user must click on the blue down arrow in the data field to display the results window.
Adding an Auto Suggest Feature
To add an Auto Suggest Feature:
Launch P958973 Runtime Feature Definitions
2. Click Add to open the Runtime Feature Revisions form
Feature Type = Auto Suggest
Feature Name = unique name for the custom Auto Suggest object
Data Item = data dictionary item to which Auto Suggest will be applied. Auto Suggest can be applied to all forms that have this data item
No Auto Suggest (optional) = Turn this option on if you only want to use Auto Suggest at a system code level or if you want to exclude some applications within the system code from using Auto Suggest.
Business View = Select an Auto Suggest business view using the visual assist (see Adding an Auto Suggest BSVW)
Language Business View (optional) = business view for translated descriptions for the data item
Number of Characters Required = minimum number of characters a user must type in before Auto Suggest will display the results
Hot Key Required = Turn this option off if you want Auto Suggest to be triggered automatically once the required number of characters is met. Turn this option on if you want Auto Suggest to be enabled by the user clicking a blue down arrow in the auto suggest field after the minimum number of characters required is met.
3. Click OK.
Adding an Auto Suggest Business View
To create Auto Suggest business views:
In OMW, create a Business View object and click the Auto Suggest check box.
Open the Business View in Design Aid.
Choose the table or table joins you want to include in the Business View. This is the set of data that Auto Suggest will use when searching for the user typed characters.
The first column must be the data item that will be populated into the field where Auto Suggest is being triggered
Add remaining columns to the Business View. There are three properties that you need to select for the remaining columns
Search Field – Select this option for the columns where you want the Auto Suggest system to search. EnterpriseOne will compare the user typed characters to values in this field (only string fields can be selected as search fields).
Display Field – Select this option to include the column in the grid display of recommended items.
Language Code - Select this option if the column contains the language code. The system will match the user's language preference with data in this column to display translated records.
Authorizing an Auto Suggest Feature
To authorize and Auto Suggest feature:
Launch P958974 Runtime Feature Authorization
2. On the Work With Feature Authorizations. Click Add.
3. On the Feature Authorization Revisions
Enter the environment on which this feature should be available
This feature can be available at the user, role, or *PUBLIC level
Enter the name of the Auto Suggest object your created in P958973
This feature can be available at the form, object, or product level.
4. Sign out and back in and the Auto Suggest feature should work for the applications you authorized.
Have a question about Best Practices in JDE System Management, please contact us at
inquiries@GetGSI.com!