SAM V2:Reports

From AMACWiki
Jump to: navigation, search

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.

Back to SAM V2 Tables

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.