Skip to content
Bitta Apps

Chapter 2 of 4Page 2 of 2

Inspect objects and data

View and edit data in any table

Open any Business Central table in the Data Inspector, choose columns, set filters, edit with or without validation and triggers, and keep an audit trail.

updated: applies-to: 1.0.0.0

The Data Inspector shows and edits the records of any table.

Open it

Choose the Data Inspector tile and then Choose Table, or choose Data on a table in the Object Inspector.

Data Inspector showing the Payment Terms table, 11 of 11 records loaded, the access mode and a grid with code, due date calculation and description

The header shows the table number and caption, the filters, how many records are loaded, and the access mode.

Focus the grid

  • Choose Columns picks the fields you see.
  • Set Filters and Clear Filters narrow the records.
  • Load More fetches the next records, and Refresh reads them again.

Edit

  1. Change values in the grid, or choose New Record.
  2. Decide with Validate and Run Triggers whether edits run field validation and the table triggers. The Access field tells you which mode is on.

Every edit is written to the Studio Audit Log. Protected tables need GodMode and a prompt, and people with Read Only access cannot edit.

Inspect a record

All Fields of Record, Table Fields and Table Properties show the details.

Go big

Batch Processing opens the wizard with the same table and filters, to change one field on all of them. See Batch Processing.

WARNING

Without validation and triggers, a value is written as it is. Use it for corrections you have checked, and leave it on otherwise.

Next step

Ready to try Bitta Object Runner?