Active+Query+Builder Details

Element Details: Active+Query+Builder

Available in: Logi Info

Source code name: ActiveQueryBuilder

Introduced in: v11.3.049

Normally, the AnalysisGrid is configured with a DataLayer, often consisting of a SQL SELECT query. The user is then restricted to analyzing that dataset.

The ActiveQueryBuilder allows the user to interactively select tables and joins for analysis. This is done from a "Data" tab at the top of the AnalysisGrid. The user first selects an initial table from a list. Then, if that table joins to other tables, another list appears for join selection.

The lists of tables and joins are set in .lgx files located in the _Metadata folder. Metadata.lgx files are created and managed with the Logi Studio application. To create a metadata file, first add a Metadata element under a Connection element. (Only ActiveSQL-supported connections types are supported.) Then use the Studio wizard to configure the metadata file by selecting tables, columns and joins.

When there is more than one Metadata element in the _settings.lgx definition, the user is prompted to first select a "Data Source". Once selected, the list of tables appears. Use the MetadataIDs attribute to control metadata selection in the AnalysisGrid.

Metadata LGX files can be built using the Logi Studio Metadata Builder utility. To run, the utility requires installation of the Logi Info Self Service Reporting Module product. Then the Metadata Builder may be run from Studio by selecting an ActiveSQL-supported Connection element or its child Metadata element.

ATTRIBUTES

Click attribute Name to drill down for more information.

Name

Possible Values

Description

ActiveSqlBufferSize

UserDefined

An integer representing the maximum number of rows buffer when reading from the data source. The buffer is used when paging tables so that the data source need not be queried for every new page of rows. Defaults to 200.

HideColumnSelection

True

False

When HideColumnSelection="True", the ActiveQueryBuilder uses a simplified interface allowing the user to select tables, but not columns. All columns are automatically selected.

MetadataIDs

(Text)

MetadataIDs specifies one or more Metadata elements defined below Connection elements. Metadata IDs may be entered in a comma-delimited list. The default is to list all Metadata choices as defined under settings' Connections. When there is more than one Metadata, the user is offered a choice of data sources.

TemplateModifierFile

UserDefined

Some elements employ a definition file as a template. The definition contains language and culture specific Caption attributes that you may want to change. Or you may simply want to change the captions to better suit your application. The TemplateModifierFile is an XML file with elements pointing to other elements in the template to be changed. All other attributes get applied in the template. For example, the Dashboard2 element has a template file (rdTemplate\rdDashboard\rdDashboard2Template.lgx) several Label elements. One has an ID="lblAddPanelsTitle". The Caption can be changed with the following XML in the TemplateModifierFile: You can set attributes for any number of elements. Examine the template file to learn the ID and Caption attributes you may want to modify. The above example shows how to identify template elements with an ID attribute. Alternatively, you can also identify elements with an XPath expression. In this example, we change an attribute of the InteractivePaging element: For a more detailed list of modifier actions see the following DevNet article. TemplateModifierFiles can be in any folder accessable to the web application. When a directory location is not specified, the default location is the _SupportFiles folder.

PARENT ELEMENTS

Click element to drill down for more information.

Analysis Grid

CHILD ELEMENTS

Click element to drill down for more information.

Generated Sql Plugin Call