Retrieve Value From Table
Solution No. 130
Takes a value from the specified field in the specified table and loads it into an Action Result variable, which can then be used in subsequent actions.
So Where Would We Use It?
Useful when building an action set, Retrieve Value From Table will pull the value from a different table and assign it as an Action Result, or place the value directly into a field on the screen. You can then call upon the Action Result elsewhere within your action set.
Properties
To set the properties for this action, follow these steps:
1. Select Retrieve Value from Table from the Action dropdown list.
2. Select From Table from dropdown list.
3. Select From Field from the dropdown list.
4. Select Where Field from the dropdown list.
5. Select condition from the value is dropdown list.
The choices are:
- Type In – sets the condition to a value that the user types in manually.
- Action Result – sets the condition to a user-defined action result.
- Value From Screen – sets the condition to a value pulled from a specific field within the specified screen.
- Value From Session – sets the condition to a value that results from the current session information.
- Value From Row – sets the condition to a value from a specified row.
6. If you selected Type In for Step 5, enter the predefined value and proceed to Step 7; otherwise, specify a value from the dropdown list.
7. Click on Use Advanced Script if you would like to query using scripts. Select the Script (previously assigned as an action result) from the dropdown list and proceed to Step 13; otherwise, continue with step 8 for regular scripts.
8. Click on and Where if you would like to specify more conditions; otherwise, proceed to Step 13 (if applicable). Click on remove where to remove this condition.
9. Select Where Field from the dropdown list (if applicable).
10. Select Value Is (if applicable).
The choices are:
- Type In – sets the condition to a value that the user types in manually.
- Action Result – sets the condition to a user-defined action result.
- Value From Screen – sets the condition to a value pulled from a specific field within the specified screen.
- Value From Session – sets the condition to a value that results from the current session information.
- Value From Row – sets the condition to a value from a specified row.
11. If you Selected Type In, enter the predefined value; otherwise, select Value from dropdown.
12. Click on and Where if you have even more conditions to filter by. Repeat Steps 9 through 11; otherwise, proceed to Step 13, (if applicable). Click on remove Where to remove this condition.
13. Select If multiple results from the dropdown list.
The choices are:
- Retrieve First – retrieves the first value stored for the record.
- Retrieve Last – retrieves the last value stored for the record.
- Retrieve Minimum – retrieves the minimum value stored for the record.
- Retrieve Maximum – retrieves the maximum value stored for the record.
- Retrieve Sum – retrieves the sum of all records stored.
- Retrieve Count – retrieves the count of all records stored.
14. Select Place value in from the dropdown list.
The choices are:
- Action Result – sets the condition to a user-defined action result.
- Value From Screen – sets the condition to a value pulled from a specific field within the specified screen.
15. Specify how you will use the results from the Place value in dropdown list; enter a name for the Action Result or select the field on the screen to place the value.
16. Enter Internal note (Optional).
17. Click Save & Close to save changes and close the action properties window; otherwise, click Cancel to close the window without saving.
| Created by | Saudia A. on | Oct-18-2011 |
| Last modified on | Sep-17-2015 |
