In this lesson you will also use the EGL content assist feature, a tool that you can use to complete programming statements without having to type the entire statement.
customers
The Create a New EGL Data Variable window looks like this:

The Page Data view looks like this:

By adding entries to the Page Data view, you have also added an array of records to the JSF handler. In the next section, you will create the related fields on the web page.
The Insert List Control window opens. This window lists all of the fields in the database record. You can use this window to choose which fields to display on the page.
With this option selected, the data on the page is displayed in read-only output fields. If you choose Updating an existing record, the fields on the page are input fields that you are able to type into, and beneath the fields will be buttons for you to bind actions to. You'll create this type of field on another page. For our purposes, the Creating a new record option is the same as Updating an existing record except that the default buttons are different.
The Insert List Control window looks like this:

The page looks like this example:

The columns in the data table have headings based on the names of the fields in the database. You can change these headings by clicking them, opening the Properties view, and changing the Value field.
The three text fields in the data table, which appear as {CUSTOMERID}, {FIRSTNAME}, and {LASTNAME}, represent the places where the database information will appear on the page.
The next step is to add code to this page that calls a function in the CustomerLibrary.egl library. That function reads the data from the database and makes it available to the page.
The allcustomers.egl file opens in the editor. This file holds a JSF Handler part. In the next steps, you add code to this JSF Handler that retrieves data from the database and puts it on the page.
This is the line of code that defines the record variable you created to display on the page. You also need to define a record to store the success or failure code of the SQL call.
status StatusRec;

The keyboard shortcut for this feature is Ctrl+Shift+O. EGL checks all files visible to it, locates the necessary information, and adds an import statement at the top of the file.
Now you have the record to be retrieved from the database and the SQL status record. The final step in adding the data to your page is to pass these two variables to the function that accesses the database. This function, named GetCustomerListAll(), was created by the Data Access Application wizard in a previous lesson.
Note the lines within braces that follow the handler declaration. These lines assign values to properties of the JSF Handler. In EGL, properties are name-value pairs that modify how a part behaves. Most types of EGL parts have one or more properties, and each kind of part can have different properties. In this case, the JSF Handler has four properties defined:
cust
Now the new line of code reads CustomerLib.
Now the new line of code reads CustomerLib.GetCustomerListAll(customerArray, status) and the customerArray argument is highlighted.
CustomerLib.GetCustomerListAll(customers, status);
Also
note that there is a new import statement near the
top of the file that reads import eglderbydb.access.CustomerLib; This
line imports the library so you do not need to write out the complete
path to the library in your code and instead can refer to it directly. The content assist added this import statement automatically. If you had not used the content assist or the Organize Imports feature to create this import statement, you would have to specify the explicit location of the library, qualifying the library name with the following names: eglderbydb.access.CustomerLib.

If you see any errors marked by red X symbols in the editor, make sure your code matches the code in this file: Completed allcustomers.egl file after lesson 6.
Now the page is ready to be run on the server. Follow these steps to test it and see how the database data appears on the page.
As in the previous lesson, the web page opens in a web browser inside the workbench. This time, the dynamic data appears on the page. If you do not see the dynamic data, click the refresh icon next to the address bar. The page looks like this:
