SAM V2:Reports
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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. |