Element Details: Right.SQL
 Back


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.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
ConnectionID
UserDefined
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.
ID
UserDefined
(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.
Source
UserDefined
(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.



PARENT ELEMENTS

Click element to drill down for more information.



CHILD ELEMENTS

Click element to drill down for more information.

Calculated Column Condition Filter


 Back to top