Element Details: Authentication.SQL
 Back


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

The AuthenticationRule.SQL element defines a rule by which the user gets authenticated. Its Source attribute can be set to a SQL statement that verifies the validity of the user's input from the logon page. @Request tokens can be used in the Source Attribute to access incoming data or user input. Important Note: The SQL statement can return two columns. It will make the first value available to you as "@Function.Username~" and the second value as "@Function.UserID~".



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.
Source
UserDefined
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