SAM V2:Reports

From CIDI Wiki
Jump to navigation Jump to 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


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.