...
- Property: The field on the object being changed that will be updated. These properties correspond to fields that can be seen when a record is viewed
- New Value: The desired value to update the selected property to when the change is executed
| Type of Field | New Value formatting | Notes |
|---|---|---|
| Boolean (check box) | true or false | Entering the value "true" will populate the checkbox. Entering the value "false" will leave the box unchecked. |
| Text | "text" | Must include the quotations around the value that should appear in the field. |
Date | ('MM/DD/YYYY') | Enter the date that should appear in the field instead of MM/DD/YYYY. Must be formatted with all digits in the definition. |
| Info | ||
|---|---|---|
| ||
If trying to mass change a field to blank, the word "null" (no quotation marks) can usually be entered as the New Value. |
...
- Load Definition: Select a mass change definition from the drop down. Definitions available in this list are those that were created in Maintenance mode for the current grid.
- Script Definition: The Property and New Value fields will populate based on the definition loaded. These fields are configured in Maintenance mode and cannot be changed in this grid in the execution view.
- Mass Change Parameters: Some definitions are configured to allow values to be entered when in Execution mode. If available, these will show to the right of the Script Definition section.
Submit Mass Change: Processes updates specified by mass change definition to ALL records currently showing in the grid. The Note above shows the number of records that will be modified. The grid should be filtered to include ONLY the records that should be updated prior to submitting the change.
Info title Tip Once a Mass Change has been submitted, there is no way to simply "undo" a change. It may be helpful to generate a Report of the grid to a Comma Separated Values or Excel-Data format prior to submitting the change. If there is a situation where a change needs to be reverted, this can be useful in generating a correction spreadsheet.
SSDT Mass Change Definitions
A standard SSDT Mass Change definition is available on the Users grid to Change External Authentication flag.
Downloadable Mass Change Definitions
...