Difference between revisions of "SYSREPORTS"
From Lianjapedia
Yvonne.milne (Talk | contribs) (→Description) |
Yvonne.milne (Talk | contribs) |
||
| Line 40: | Line 40: | ||
[[Category:Reference]] | [[Category:Reference]] | ||
[[Category:Lianja v5.3]] | [[Category:Lianja v5.3]] | ||
| + | [[Category:System Tables]] | ||
Latest revision as of 09:41, 22 April 2020
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
