Difference between revisions of "SAM V2:Reports"
Jump to navigation
Jump to search
(New page: The reports table is one of the administrative tables in SAM V2. It is used to store the SQL code that is executed when a user runs a report under the Reports menu. N...) |
(→Fields) |
||
Line 17: | Line 17: | ||
|- | |- | ||
|query | |query | ||
|The SQL that is executed when the report runs. | |The [[Wikipedia:SQL|SQL]] that is executed when the report runs. | ||
|- | |- | ||
|rid | |rid |
Latest revision as of 15:30, 20 June 2008
The reports table is one of the administrative tables in SAM V2. It is used to store the SQL code that is executed when a user runs a report under the Reports menu.
New or custom reports can be added to SAM V2 by creating new report records, however, a solid understanding of the SAM V2 database structure as well as knowledge of SQL is required.
Fields
The fields of the permission table are:
Field | Description |
---|---|
last_update | Date the records was last updated. |
query | The SQL that is executed when the report runs. |
rid | Unique ID# of the record. |
title | The title of the report. |
table_name | The name of the table under which the report will be listed on the Reports menu. |
updated_by | User who last modified the record. |