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.
The fields of the permission table are:
|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.|