Report Properties: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
Below is an example report. | 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 | |||
[[file:User Reports Properties.png|700px]] | [[file:User Reports Properties.png|700px]] | ||
Revision as of 11:06, 22 August 2024
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
