Difference between revisions of "SYSREPORTS"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "==Purpose== System table for Lianja Cloud Server deployed Reports ==See Also== Report Section Attributes, Report Builder, Report Options, Reports Workspace, [...") |
Yvonne.milne (Talk | contribs) |
||
(One intermediate revision by the same user not shown) | |||
Line 6: | Line 6: | ||
==Description== | ==Description== | ||
− | The sysreports table | + | 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. | ||
{| class="wikitable" width="100%" | {| class="wikitable" width="100%" | ||
Line 38: | 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