Schema Browser
The Schema Browser is a read-only reference tool within Commander4j that allows users to explore the structure of the application database. It is intended for use when building custom reports, writing queries, or understanding where particular data is stored.
Using the Schema Browser
The screen is divided into two panels:
- Left panel — Tables
- Lists all application database tables. Scroll through the list and click a table name to select it.
- Right panel — Fields
- Automatically populates with the column names available in the selected table when a table is chosen in the left panel.
Both panels are read-only. No data can be edited or deleted through the Schema Browser.
Purpose
Commander4j stores its data across more than 100 database tables, all prefixed with APP_. When creating a custom report in JasperSoft Studio, or when writing a query in the Report Admin screen, it is necessary to know which table holds the required data and what the column names are. The Schema Browser provides this information without needing direct access to the database management tool.
Related Tools
For users building custom reports, the following documentation is also relevant:
- Standard Reports — how to duplicate and customise existing JasperReports templates
- Report Admin — managing report definitions within Commander4j
- System Keys — system-wide configuration settings stored in the control tables
See also: Standard Reports, Report Admin, Report Properties