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) (→Description) |
||
| 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%" | ||
Revision as of 06:24, 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
