OP Database Viewer

Version 20.5

This window map article points out some of the important aspects of the window you're working with in OP but is not intended to be instructional. To learn about topics related to using this window, see the Related Articles section at the bottom of this page.

About OP Database Viewer

Path: Tools tab > Database Viewer button

The OP Database Viewer functions as a database viewer and SQL query tool.  The OP Database Viewer allows you to run, save, and export data within the database viewer to quickly provide all the data necessary based on a query.

NoteThe Database Viewer accesses the same database as OP.  If you run a query that filters a lot of data, your database could become sluggish and affect your users.  It is recommended to run queries during hours when users are not running OP.

OP Database Viewer Map

Number
SectionDescription

1

Table List panelThe Table List panel contains all the available database tables found in the OP software.

2

Table Data panelThe Table Data panel displays all the data for the selected database table.

3

Fields tabThe Fields tab lists the data contained within each selected database table.

4

Data Grid tabThe Data Grid tab lists the data contained within each selected database table.

5

Data Details tabThe Data Details tab lists the details for each selected line in the Data Grid tab.

6

Find by Name/Description tabThe Find by Name/Description tab searches for a particular data element.

7

SQL tabThe SQL tab groups particular elements from the database table based on the selected query.  You can create, run, and export queries in this tab. Query results are exported as a .csv file, which can be opened in Excel. Created queries can also be selected in the SQL Jobs tab.

8

SQL Jobs tabThe SQL Jobs tab groups multiple queries (created in the SQL tab) into jobs. Jobs create multiple .csv files in a particular folder. You can create, run, export, and import SQL Jobs using this tab. Jobs can be created with or without the header row, to ensure proper formatting for compatibility with outside vendors.
Version 20.4

About OP Database Viewer

Path: Tools tab > Database Viewer button

The OP Database Viewer functions as a database viewer and SQL query tool.  The OP Database Viewer allows you to run, save, and export data within the database viewer to quickly provide all the data necessary based on a query.

Note: The Database Viewer accesses the same database as OP.  If you run a query that filters a lot of data, your database could become sluggish and affect your users.  It is recommended to run queries during hours when users are not running OP.

OP Database Viewer Map

Number
SectionDescription

1

Table List panelThe Table List panel contains all the available database tables found in the OP software.

2

Table Data panelThe Table Data panel displays all the data for the selected database table.

3

Fields tabThe Fields tab lists the data contained within each selected database table.

4

Data Grid tabThe Data Grid tab lists the data contained within each selected database table.

5

Data Details tabThe Data Details tab lists the details for each selected line in the Data Grid tab.

6

Find by Name/Description tabThe Find by Name/Description tab searches for a particular data element.

7

SQL tabThe SQL tab groups particular elements from the database table based on the selected query.  You can create, run, and export queries in this tab. Query results are exported as a .csv file, which can be opened in Excel. Created queries can also be selected in the SQL Jobs tab.

8

SQL Jobs tabThe SQL Jobs tab groups multiple queries (created in the SQL tab) into jobs. Jobs create multiple .csv files in a particular folder. You can create, run, export, and import SQL Jobs using this tab.