SYSREPORTS
From Lianjapedia
Contents
Purpose
System table for Lianja Cloud Server deployed Reports
See Also
Report Section Attributes, Report Builder, Report Options, Reports Workspace, System Tables
Description
System Tables are system defined read-only tables. You can query these tables using the SELECT statement.
The sysreports table 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