The Lookup Form
The Lookup form allows the user to query GP for current values and to select those values when populating an eConnect transaction. In the following example, we are using the Lookup form to get a current Batch ID from GP.
Clicking on the magnifying glass on the BACHNUMB cell will open the Lookup form, which will display a list of the available Batches.
Each of the displayed columns is sortable and filterable. Clicking the downarrow in the column header will display the filter form, which allows the user to sort the list and to filter values.
There are several ways to select values to return. Note that only cells in the same row will be returned. Clicking on cells in a different row will deselect any currently selected cells.
Note that values in darkened columns will not be returned by the lookup operation. There are situations where not all of the displayed information is useful and there are some cases where it can actually be detrimental.
Also, some information displayed by the Lookup form is not directly useful for eConnect transactions, but is included as it may be useful to a developer who is using the application. For example, DEX_ROW_ID and DEX_ROW_TS values are often included in the information displayed as it could be useful for the user but these values are not included in the eConnect transactions.
- Click on a cell will select the cell. Clicking on the cell a second time will deselect the cell.
- Multiple cells will be selected by pressing the control key while clicking.
- A group of cells will be selected by pressing the shift key while clicking.
- The entire row of cells will be selected by clicking on the row header.
- Double-clicking either a row or a cell will cause the form to close and the selected values to be returned.
The names of the returned values are used to determine which eConnect elements to populate. The returned column names are matched to eConnect elements with identical names. If only a single value, for example named BACHNUMB, is returned then this value is used to populate the eConnect node named BACHNUMB. If multiple values are returned, then each value is matched to an eConnect element with the same name.
A more complex example is a SOP Header and its customer information. Here is an empty taSopHdrIvcInsert transaction:
Clicking on the magnifying glass on the CUSTNMBR value cell will launch the Lookup form with a list of available customers. This list includes not just the customer ID (CUSTNMBR), but name, address, phone numbers, etc. In this example, we select the entire row for AARONFIT001:
When we return to the main form, we will see that several eConnect elements have been populated with values that were selected in the Lookup form:
