DB Tools

The database view tool is useful for configuring solutions and troubleshooting data issues. You can use this feature to:

Inspect database content and view the contents of tables
Run SQL queries to directly retrieve specific information
Display record counts to determine the number of records in each table

Consultants and support teams can leverage this tool to assist customers in identifying missing data and investigating the root cause of problems by examining the database contents.

You can enable this feature in Setup > Settings > Logging > Special settings and then specify the value 1 on EnableDBTool.

Note: You must have administration rights to access this feature.

From the menu, select Data Administration > DB Tools.
On M3DmpDBTool, select Edit > New Query to open a new SQL Query.
On SQLForm, users can copy and export the result of the query. Select from any of these actions:

Copy

Select this option to copy the contents from the selected queries.

Note: A copy option is available in the grid to copy highlighted records, including headers. You can right-click to access enhanced copy options. You can copy selected cells and their headers, copy multiple cells, or copy only column names from the column header menu.

Export

Select this option to export the contents from the selected queries. A prompt is displayed to ask for the location where the CSV file is saved.

Run

Select this option to run the SQL query specified.
On M3DmpDBTool, select File > Export. Specify this information:

Table List

Select this option to export the list of the tables to a file.

Selected Table

Select this option to export a table with content to a file.

Search bar

You can filter table names based on user input.
On M3DmpDBTool, select Settings > Show Recordcount to display the number of records existing in each table.