Element Details: User+Roles.SQL
 Back


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

The UserRoles element controls how the server determines the current user's list of Roles or Groups.

Use UserRoles.SQL to get the list from your own custom database. In the Source attribute, enter a SQL statement which returns roles in the first column. Multiple roles can be obtained either by having one role per record, or multiple roles can be comma-delimited in a single record.



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


 Chart Debug