Difference between revisions of "SAM V2:Reports"

From AMACWiki
Jump to: navigation, 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 14: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.

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.