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.
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 | Section | Description |
1 | Table List panel | The Table List panel contains all the available database tables found in the OP software. |
2 | Table Data panel | The Table Data panel displays all the data for the selected database table. |
3 | Fields tab | The Fields tab lists the data contained within each selected database table. |
4 | Data Grid tab | The Data Grid tab lists the data contained within each selected database table. |
5 | Data Details tab | The Data Details tab lists the details for each selected line in the Data Grid tab. |
6 | Find by Name/Description tab | The Find by Name/Description tab searches for a particular data element. |
7 | SQL tab | The 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 tab | The 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 | Section | Description |
1 | Table List panel | The Table List panel contains all the available database tables found in the OP software. |
2 | Table Data panel | The Table Data panel displays all the data for the selected database table. |
3 | Fields tab | The Fields tab lists the data contained within each selected database table. |
4 | Data Grid tab | The Data Grid tab lists the data contained within each selected database table. |
5 | Data Details tab | The Data Details tab lists the details for each selected line in the Data Grid tab. |
6 | Find by Name/Description tab | The Find by Name/Description tab searches for a particular data element. |
7 | SQL tab | The 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 tab | The 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. |
