SYSREPORTS
From Lianjapedia
Revision as of 06:01, 22 April 2020 by Yvonne.milne (Talk | contribs)
Contents
Purpose
System table for Lianja Cloud Server deployed Reports
See Also
Report Section Attributes, Report Builder, Report Options, Reports Workspace, System Tables
Description
The sysreports table is generated dynamically and returns information on the Lianja Cloud Server deployed Reports.
| Column | Data Type | Width | Description |
|---|---|---|---|
| AUTHOR | C | 80 | Report author. |
| CATEGORY | C | 80 | Report category. |
| REPORT | C | 80 | Report name. |
| DESCRIPTION | C | 80 | Report description. |
| DATECREATED | C | 20 | Report creation date and time ('YYYY-MM-DD hh:mm:ss'). |
| DATEMODIFIED | C | 20 | Report last modification date and time ('YYYY-MM-DD hh:mm:ss'). |
| PERMREAD | C | 255 | Report read permission roles. |
Supported from Lianja v5.3.
Example
select * from sysreports
