Element Details: Right.SQL

Available in: Logi Info Source code name: Right.SQL

Rights control what user roles are allowed to view a report or report element, or perform an action. You should have a Right element for each function that you want to securely control in the report application. Each Right is associated with one or more Roles, and any user that has any of the Right's Roles has access to reports and report elements that require that Right. Right.SQL should return a list of Roles in the first column, or multiple Roles in a single record as a comma-delimited list.


Click attribute Name to drill down for more information.

NamePossible ValuesDescription
Specifies a connection to a data source that is defined in the Settings. For elements connecting to relational databases, default is the first Connection element in _settings.lgx.
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
(Required) A SQL statement that returns a set of records. Use tokens, such as @Request and @Session, inside of the SQL command to control the result set.


Click element to drill down for more information.


Click element to drill down for more information.

Calculated Column Condition Filter

 Back to top