Batch Processing
Change many records with Batch Processing
Change one field on many records: choose the table, field and filters, write the new value as an AL expression, verify it, run it, and undo it from the history.
updated: applies-to: 1.0.0.0
Batch Processing changes one field across many records with a guided wizard. Every run is logged with the old and the new value of each record, and can be undone.
Open it
Choose the Batch Processing tile, Batch Processing in the Data Inspector, or Batch in Code Studio (with Bitta Code Studio). Batch Processing History is in the Data menu.
The steps
- Table and Field: choose what to change.
- Filters: pick a filter field and type a filter in the usual syntax, such as 10000..20000, <>0 or A*|B*. The wizard shows how many records are within the filters.
- Current values: check the first records within the filters.
- New Value: write an AL expression, such as UpperCase(Rec.Name) or Rec."Unit Price" * 1.05, and choose Verify to see the result on the last record.
- Options: Validate Field, Run OnModify, and A person must apply this batch to require a second person.
- Execute: review the summary and run it. The result shows the records modified, unchanged and failed.
Before you run it, Old and new values shows the current and the new value of the first records within the filters:
Undo
Open Batch Processing History, select the run and choose Undo. The earlier values are restored. Records shows each record of a run with its old and new value.
What is checked
Batch runs go through the Security Guard of Bitta Apps Studio: the access level of the person, protected tables and the sandbox-only setting. Runs and undos are written to the Studio Audit Log.