Skip to content
Bitta Apps

Chapter 3 of 4Page 1 of 1

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

  1. Table and Field: choose what to change.
  2. 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.
  3. Current values: check the first records within the filters.
  4. 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.
  5. Options: Validate Field, Run OnModify, and A person must apply this batch to require a second person.
  6. Execute: review the summary and run it. The result shows the records modified, unchanged and failed.
Batch Processing wizard on step 4 of 9, Filters, with the No. field filtered to 10000..50000 and 5 records within the filters

Before you run it, Old and new values shows the current and the new value of the first records within the filters:

Batch Processing wizard on step 7 of 9, Old and new values, with item unit prices raised by 5 percent and every record marked Modified

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.

Next step

Ready to try Bitta Object Runner?