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: Sql+Query
Back
Available in: Logi Info
Source code name:
SqlQuery
The ActiveSQL SqlJoin element joins two tables or queries together. ActiveSQL automatically generates the appropriate SQL join syntax.
Add a SqlQuery under a SqlJoin element to define the table or query to be joined.
ATTRIBUTES
Click attribute Name to drill down for more information.
Name
Possible Values
Description
ID
UserDefined
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.
Sql Join
CHILD ELEMENTS
Click element to drill down for more information.
Sql Aggregate Column
Sql Calculated Column
Sql Condition Filter
Sql Group
Sql Join
Sql Sort
Sql Time Period Column
Back to top
Your session will automatically end soon.
Continue the Session