Logi Composer
Documentation
Getting Started
Knowledge Base
Forums
Logi Report
Documentation
Getting Started
Knowledge Base
Forums
Logi Report API Doc
Logi Info
Documentation
Getting Started
Knowledge Base
Forums
Logi Info Sample Center
Logi Info Upgrade Advisor
Other Products
Izenda
Exago
Support
Submit a Ticket Request
View Support Tickets
License Manager
Product Download
Forums
Events
☰
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.
Name
Possible Values
Description
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
Your session will automatically end soon.
Continue the Session