SYSREPORTS
From Lianjapedia
Revision as of 09:41, 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
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