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.
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
- Change values in the grid, or choose New Record.
- 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.