Element Details: Active+Query+Builder

Available in: Logi Info Source code name: ActiveQueryBuilderIntroduced 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.


Click attribute Name to drill down for more information.

NamePossible ValuesDescription
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.
When HideColumnSelection="True", the ActiveQueryBuilder uses a simplified interface allowing the user to select tables, but not columns. All columns are automatically selected.
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.
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.


Click element to drill down for more information.

Analysis Grid


Click element to drill down for more information.

Generated Sql Plugin Call

 Back to top