Report Properties

From Commander4j
Revision as of 11:06, 22 August 2024 by Dgarratt (talk | contribs)

Below is an example report.

Lets say for example you want to export all pallets in the database in a certain date range.

First of all you will need to know the names of the tables and columns in the database and to assist with this you can use the Schema Browser.

The SQL statement we can experiment with is as follows :-

SELECT * FROM APP_PALLET