Update Several Records at Once
On this page
In a Web App grid, select several records to change their fields with Batch Update, or add, replace, or remove all their tags with Tags. Both commands are on the grid toolbar's Actions menu; they are not available from an individual row's action button. For records that have a workflow, you can also run one workflow action on the selection.
Prerequisites
- Batch Update needs the Batch Update permission, one of the Advanced permissions granted through a security role (see Security Roles and Permissions Reference). Without it, choosing Batch Update shows "You do not have enough permissions to use this function." instead of opening the drawer.
- If the page does not allow editing, choosing Tags shows "You do not have enough permissions to use this function."
In the Web App
Where the commands are offered
- A related-objects grid inside a form has no Actions button.
- The Actions button is disabled until you select at least one record, except on a grid inside a form that has global actions. With nothing selected, Tags is disabled with "No records selected".
- Tags appears only for a class that has a Tags column.
- Batch Update is not offered on All Tickets, All CIs, My Tickets, My Starred, My Followed, Discovered Installations, Recurrent Tickets, and the Software Catalog, or in Advanced Search and the dependencies dialog. On a dashboard's grid, Batch Update is listed but always answers with the "not enough permissions" message.
Change fields with Batch Update
- In a grid, select the records you want to change.
- On the toolbar, open the Actions menu and choose Batch Update. The Batch Update drawer opens.
- Select the check box of each field you want to change, and then click Next. Next stays disabled until at least one field is selected. The fields are sorted by their internal names, not by the labels you see, so the list may not look alphabetical.
- Enter a value for each field. Only the fields you selected are shown, in the order you selected them. A banner shows how many records the update will affect.
- To make this update without running workflow triggers, select the check box that skips them.
- Click Start.
- Review the result. The drawer shows "Updating completed." with the number of selected records that were updated, in the form "N out of M records have been successfully updated.", or shows an error. To make further changes to the same records, click Back. To close the drawer, click Finish.
No field is required in the Batch Update drawer, even a field that is mandatory elsewhere.
Which selected records Batch Update changes
- For records such as incidents and computers, Batch Update changes only the selected records you are allowed to modify. If your role cannot modify the class at all, the update still runs to the end and reports that 0 records were updated. If your role can modify only some records, for example only the tickets you are assigned to, only those records are updated.
- The result gives the count only; it does not name the records that were left out.
Fields that Batch Update offers
The field list contains the class's editable fields. It leaves out:
- Calculated fields, image fields, read-only fields, and HTML fields.
- Fields that are never offered to users, and fields on the product's built-in list of hidden fields for that class.
- Fields that your license does not cover.
- The Tags field. To change tags, use Tags on the Actions menu.
Add, replace, or remove tags on several records
- In a grid, select the records you want to tag.
- On the toolbar, open the Actions menu and choose Tags. The Tags pane opens with the text "Choose how to modify tags for N selected records", where N is the number of records the operation will affect.
- Choose Add new tags (selected when the pane opens), Replace existing tags with new ones, or Remove all existing tags.
- For Add new tags or Replace existing tags with new ones, choose the tags to apply. Remove all existing tags clears the tag field and disables it.
- Click Start. Start stays disabled until you choose at least one tag, unless you chose Remove all existing tags.
- Review the result, and then click Finish to close the pane.
The result message tells you whether all, some, or none of the selected records were updated. For a partial update, it includes both counts; when no records were updated, it reports an error. The messages are listed in Tags.
Run a workflow action on several records
In a grid of records that have a workflow, you can run a workflow action on several records: select them, open the Actions menu, point to Actions, and choose the action; see Perform Actions on Records.
With several records selected, the Actions submenu offers only the actions that fit all of them:
- An action that may run only on a single record is not listed.
- An action is not listed unless one of your security roles may run it.
- An action that is not valid for the status of every selected record is hidden or shown dimmed, as the system-wide hidden-or-dimmed setting decides. An action set up without a status list counts as not valid when any selected record is in a closed status.
When the action opens a form or a wizard for several records:
- The fields do not show the selected records' values. A field starts empty, or with the value the action's form sets for it; a value that the form calculates from the record's fields is calculated as for an empty record. A Yes/No field starts cleared.
- Each field has a marker beside it. After you change a field, the marker shows an icon. Click it to withdraw the change: the field returns to its starting value and is left out of the update.
- A value you type and then delete still counts as a change and is sent empty. To leave the field out, click its marker.
- For a field that the business logic handles, the marker always shows its icon, even before you change the field. Clicking it shows "This value is being handled by the business logic and cannot be suppressed." and resets nothing.
If one of the selected records was changed or deleted after the form opened, the whole run is refused and the action runs on none of the records; see Perform Actions on Records.