The Core+ Database Viewer (DBView) lets you view the structure of the Core+ database, view the data held within its tables, and run basic queries. The data is read-only, so no changes can be made. Access is controlled by role-based permissions.
What you can do in DBView
Open DBView and view the database tables — see the Open DBView and view the database tables article.
View a table's structure on the Schema tab — see the View a table's structure on the Schema tab article.
View and filter table data on the Data tab — see the View and filter table data on the Data tab article.
Run SQL queries on the SQL tab — see the Run SQL queries on the SQL tab article.
Export data to XLSX or CSV — see the Export data to XLSX or CSV article.
Add DBView to a role
Before anyone can use DBView, the DBView menu item, found under Admin Tools, must be added to each applicable role.
Select Roles from the Administration menu. The User Role Search page is displayed.
Search for the role using the Role Name field, then open the role.
Select the Menu tab.
Select the DBView menu item in the left-hand column. To select multiple items, select one, then hold Ctrl and select the others.
Click the central single arrow to move the menu item to the right-hand column.
Select Save
🤓 Tip: To apply the same menu items to another role, click Copy Menu Items.
For full details on configuring roles, see the Roles article.