Start/End Loop Through Table
Solution No. 131
Start Loop Through Table
This must be used in conjunction with the “End Loop Through Table”. All subsequent actions will be processed between “Start Loop Through Table” and “End Loop Through Table” for each record in the specified table that meets your criteria. If you want to search through all records, set your "Where" to be "RecordID", "Type In", ">0". Note: each record's Record ID will be temporarily loaded into "Action Result (for Record ID)" so that it is easily available for use in actions inside your loop.
So Where Would We Use It?
The Start Loop Through Table action will loop through the specified table and return any records that match the criteria. The records that match the criteria will have the actions between Start Loop Through Table and End Loop Through Table applied to them.
Properties
To set the properties for this action, follow these steps:
1. Select Start Loop Through Table from the Action dropdown list.
2. Select the Table from the dropdown list.
3. Select the Field to apply successive actions from the Where dropdown list.
4. Select condition from the dropdown list.
The operator choices are:
- Equal to – displays all records that exactly match.
- Not equal to – displays all records that do not exactly mach.
- Greater than – lists all values that are greater than the criterion.
- Greater than or equal to – lists all the values that is greater than or equal to the criterion.
- Less than – lists all values in the field that are less than the criterion.
- Less than or equal to - lists all values in the field that are less than or equal to the criterion.
- Starts With – lists all values in the field that starts with the criterion.
- Ends With – lists all values in the field that ends with the criterion.
- Build Selection List – lists all values from the user-defined list.
5. Select the Value from the 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.
- Value from Calendar – sets the condition to a value that is pulled from a value in a Calendar.
6. If you selected Type In for Step 5, enter the predefined value and proceed to Step 7; otherwise, specify a value in the dropdown list below.
7. Click and Where if you have more conditions, note you can add one more condition by clicking the 2nd and Where. If selected then repeat steps 3 through 6. To remove these additional conditions, click on remove Where.
8. Select Order By (optional), if you have a preferred way to display the results. Select the 1st field from the dropdown list and select Ascending or Descending order. If desired you can select a 2nd field to order the data by, selecting a field from the dropdown for then by and selecting Ascending or Descending order.
9. Select to display only distinct values (Optional) for a field from dropdown.
10. Enter the Action Result name.
11. Enter Internal note (Optional).
12. Click Save & Close to save changes and close the action properties window; otherwise, click Cancel to close the window without saving.
End Loop Through Table
This must be used in conjunction with the “Start Loop Through Table” action. All subsequent actions will be processed between “Start Loop Through Table” and “End Loop Through Table” for each record in the specified table that meets your criteria.
So Where Would We Use It?
Used in conjunction with the “Start Loop Through Table” action, this allows the user to select the records they wish to include in subsequent actions. All unselected records in the table will be omitted from the action set.
Properties
To set the properties for this action, follow these steps:
1. Select End Loop Through Table from the Action dropdown list.
2. Enter Internal note (Optional).
3. 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 |
