SYSREPORTS

From Lianjapedia
Jump to: navigation, search

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