Introduction
Retrieval is a nice shortcut for users. It will often be the case that they need to enter fields whose values can be identified by the value of some other field. For example, the primary key can identify all the values in its row. When working with people, the SSN can also identify the value in its row.
Prerequisites
The entity has to be configured with the retrieval query.
|
Quick Steps |
| 1 |
Open the field properties |
| 2 |
Open the Retrieval section, then click the retrieval icon |
| 3 |
Enter the Retrieval Query, then click OK |
| 4 |
Enter the Parameters information |
| 5 |
Open the Control Mapping tab |
| 6 |
Enter the Retrieval Control IDs, then click OK |
| 7 |
Save the form |
Detailed Steps
Step 1. Open the field properties.
This is the field you want to configure retrieval for.
Step 2. Open the Retrieval section, then click the retrieval icon.
The Retrieval section contains the properties you need. Click the Retrieval icon.
The icon opens a window where you can select the Query/Method details and set the control mapping.
Step 3. Enter the Retrieval Query, then click OK
This comes from the entity. It must exist there before you can use it here.
A Retrieval Query should return only one row.
Step 4. Enter the Parameters information.
This example uses the SSN to populate the other controls.
You can also add a script method to be executed once the controls are retrieved. Script method is the java script method that is executed once the controls are retrieved.
If you want the application to check what the user enters as the SSN in the ssn textbox, select the parameter value from the available fields.
The parameter value is configured.
Step 5. Open the Control Mapping tab.
You have to tell the application which controls to populate.
Step 6. Enter the Retrieval Control IDs, then click OK.
Map the column names to the available field IDs.
In this case, select and enter the Retrieval Control IDs for First Name and Last Name from the Available Fields. The application populates First Name and Last Name.
Step 7. Save the form.
Then, run the Preview. Xelence displays the form output. You can test your updated settings.
When you have previewed your form, it should look something like this.
What are the improvements over S3 Version 6?
This process is identical.
Related Articles
Create a Lookup Form
This post is part of the Lookup Form topic. Click here to open the Lookup Form Overview.
This post is also part of Controls and Buttons topic. Click here to open Forms Toolbox Controls
#Xelence
#Forms
#ControlsandButtons