DataLayer.Shape Details

Element Details: DataLayer.Shape

Available in: Logi Info

Source code name: DataLayer.Shape

Allows specification of a SHAPE statement that returns a hierarchical rowset. It can be used to populate a DataTable and SubDataTables, creating a report which lists both parent and child rows.

In the Source attribute, you can either enter a complete SHAPE statement, or you can enter a SQL statement and then add a SubDataGroup element for each level. In the latter case, the system builds a SHAPE statement for you. (Make sure that the SQL has an ORDER BY clause so that records are ordered by their groups.) SHAPE commands are also great for computing aggregate values.

For details on creating SHAPE statements, visit http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmschierarchicalcursorsdatashapingdetail.asp.

DataLayer.Shape was an early method of creating hierarchical data for grouping. The functionality is replaced by the GroupFilter element which is easier and can be used under any kind of DataLayer.

Not available in the Java version.

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.

HandleQuotesInTokens

True

False

Handle Quotes in Tokens makes it possible to work with tokens, such as @Request tokens, that contain single quotes in their values. When set to True, any tokens in the Source attribute will have single quotes "doubled" so that they work within the SQL statement. For example, imagine a SQL statement in a Source attribute like "SELECT * FROM Customers WHERE CompanyName LIKE '@Request.Name~%' ". Then, if the Name we are searching for is "Trail's Head", the SQL executed becomes "SELECT * FROM Customers WHERE CompanyName LIKE 'Trail''s Head%' ". The default for Handle Quotes in Tokens is False.

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.

MaxRows

UserDefined

The maximum number of rows to retrieve from the data source.

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.

Xml Data

CHILD ELEMENTS

Click element to drill down for more information.

Security Filter

Subdata Group