---
title: "Database Editor Interface"
canonical: "https://help.innovyze.com/space/infoassetplanner/15794307/Database%20Editor%20Interface"
format: markdown
---
The DB Editor interface displays the tabular data selected you with a toolbar at the top to assist with data manipulation and selection.  The interface is fully editable; however, it is good for you to remember to click **Save** in the top toolbar to commit any changes to the database.

---


![image](media://c12125ca-cb13-4326-9901-5860c54634e6)

The tools within the database are described below:

> Macro (inline-media-image)

 **Refresh: **Updates the DB Editor to the latest data.

> Macro (inline-media-image)

 **Select All Records/Selected Records: **Allows you to toggle between all records vs. ArcGIS selected records.

> Macro (inline-media-image)

**Save: **Saves any changes which have been made within the DB Editor.

> Macro (inline-media-image)

 **Export: **Allows you to export selected records as PDF, Excel, or .csv files.

> Macro (inline-media-image)

 **Print: **Opens up the print preview window based on the records selected in the DB Editor table.

> Macro (inline-media-image)

 **Delete Record: **Allows you to delete a row within the DB Editor.

> Macro (inline-media-image)

 **Zoom To: **Zooms to and adds the selected element(s) to the InfoAsset Planner facility selection.

> Macro (inline-media-image)

 **Add New Map Selection: **Adds selected records(s) to the ArcMap selection.

> Macro (inline-media-image)

 **Group By Mode: **You may group records by one or more fields with this option. Simply drag-and-drop fields into the area created at the top of the table when group by mode is enabled.

> Macro (inline-media-image)

 **Field Setting: **Allows you to adjust the order of fields displayed and add custom fields. Field visibility may also be toggled.

> Macro (inline-media-image)

** Display Setting:** General display settings for the DB Editor including theme, alignment, and decimal precision.

> Macro (inline-media-image)

 **Query Builder: **Allows for queries to be applied to the DB Editor view.