View source for SAM V2:Reports

The reports table is one of the administrative tables in SAM V2.  It is used to store the [[Wikipedia:SQL|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 [[Wikipedia:SQL|SQL]] is required.

[[SAM V2#Tables|Back to SAM V2 Tables]]

==Fields==

The fields of the permission table are:

{| border="1" cellspacing="1" cellpadding="1"
!Field
!Description
|-
|last_update
|Date the records was last updated.
|-
|query
|The [[Wikipedia:SQL|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.
|}