HomeActive Query Builder - IntroductionIntroduction to the version 2.0Property groups in Active Query Builder 2

2.3. Property groups in Active Query Builder 2

Properties of the QueryBuilder component are grouped within the following options groups now.

  • MetadataLoadingOptions: Determines rules of loading database schema information to the Metadata Container. Definition of these rules results in limitation of the list of database objects displayed in the tree. It may also help to reduce metadata loading time for some database servers (eg. Oracle).
  • BehaviorOptions: Allows you to tune the way Active Query Builder parses and builds SQL queries. These properties determine the way Active Query Builder process SQL query parsing errors, define rules of working with joins (links between query objects), etc.
  • SQLGenerationOptions: Determines SQL query text generation rules: displaying of object names and expressions during the visual query building process.
  • PanesConfigurationOptions: Allows you to configure layout of the main parts of the component: Design Pane, Query Columns List, Database Schema Tree and Query Structure Tree.
  • AddObjectFormOptions: Determines appearance of the Add Object Form that lets you search and add objects to the query.
  • DatabaseSchemaTreeOptions: Contains various properties of the Database Schema Tree control. Determines sorting and default expand level of the tree.
  • MetadataStructureOptions: Contains various properties that affect on displaying of the Metadata Structure. There you may find properties to control grouping of objects by Database, Schema, Object Type, etc.
  • DesignPaneOptions: Contains various properties of the Design Pane, such as objects snapping and links style.
  • DataSourceOptions: Determines appearance of the objects and their field lists at the Design Pane.
  • QueryColumnListOptions: Contains various properties of the Query Column List control, such as grid columns width.
  • VisualOptions: Determine appearance of sub-query tabs and borders.

Below is the list of changes from the first version:

The QueryBuilder.AddObjectFormOptions group:

  • AddObjectFormOptions.VisualGrouping is deleted. N/A due to changes in the Add Form Options control.
  • AddObjectFormOptions.*ImageIndex bunch of properties is deleted. Use the MetadataStructureOptions.*ImageIndex properties instead.
  • AddObjectFormOptions.Show* bunch of properties is deleted. Use the MetadataLoadingOptions.MetadataFilter to filter by object types.

The QueryBuilder.CriteriaListOptions group is renamed to the QueryColumnListOptions:

  • CriteriaListOptions.CriteriaListFont is renamed to QueryColumnListOptions.Font.
  • CriteriaListOptions.ShowNullOrderingInSortTypeColumn is renamed to QueryColumnListOptions.NullOrderingInOrderBy.
  • QueryBuilder.UseCustomExpressionBuilder is moved to QueryColumnListOptions.UseCustomExpressionBuilder.
  • The AffectedColumns enum that's applicable to the UseCustomExpressionBuilder and the DisableDirectEditingIn properties is replaced with the same-named set:
    • AffectedColumns.Nowhere: AffectedColumns.None;
    • AffectedColumns.ExpressionColumn: AffectedColumns.ExpressionColumn;
    • AffectedColumns.ConditionColumns: AffectedColumns.ConditionColumns;
    • AffectedColumns.Both: AffectedColumns.ExpressionColumn | AffectedColumns.ConditionColumns.

The QueryBuilder.FieldListOptions group is renamed to the DataSourceOptions:

  • FieldListOptions.DefaultFieldListWidth is renamed to DataSourceOptions.DefaultWidth.
  • FieldListOptions.DescriptionColumnOptions.UseLongDescription is deleted. There's only the Description property left in the MetadataItem class.
  • QueryBuilder.CheckedFieldsCountInCaption is moved to DataSourceOptions.SelectedFieldsCountInCaption.
  • QueryBuilder.DiagramObjectColor is moved to DataSourceOptions.BackgroundColor.
  • QueryBuilder.FocusedDiagramObjectColor is moved to DataSourceOptions.FocusedBackgroundColor.
  • QueryBuilder.DiagramObjectFont is moved to DataSourceOptions.Font.
  • QueryBuilder.DefaultDiagramObjectWidth is moved to DataSourceOptions.DefaultWidth.
  • QueryBuilder.MaxDiagramObjectHeight is moved to DataSourceOptions.MaxHeight.
  • QueryBuilder.SortDiagramObjectFields is moved to DataSourceOptions.SortType.

The QueryBuilder.MetadataTreeOptions is splitted to the MetadataStructureOptions and the DatabaseSchemaTreeOptions:

  • MetadataTreeOptions.EnableEditing is deleted. It is not possible now to edit captions directly from the Database Schema Tree control. Use the Metadata Editor to edit captions or object names.
  • MetadataTreeOptions.ShowUser* properties are deleted. Use the MetadataLoadingOptions.MetadataFilter to filter by object types.
  • MetadataTreeOptions.ShowSystem* properties are deleted. Use the MetadataLoadingOptions.LoadSystemObjects property to filter out system objects.
  • MetadataTreeOptions.SynonymsNodeText is renamed to MetadataStructureOptions.SynonymsFolderText.
  • MetadataTreeOptions.TablesNodeText is renamed to MetadataStructureOptions.TablesFolderText.
  • MetadataTreeOptions.ViewsNodeText is renamed to MetadataStructureOptions.ViewsFolderText.
  • MetadataTreeOptions.ProceduresNodeText is renamed to MetadataStructureOptions.ProceduresFolderText.
  • MetadataTreeOptions.*NodeImageIndex properties are deleted. There's one image for all types of objects: MetadataStructureOptions.FolderImageIndex.
  • MetadataTreeOptions.SystemProceduresImageIndex is renamed to MetadataStructureOptions.SystemProcedureImageIndex.
  • MetadataTreeOptions.SystemSynonymsImageIndex is renamed to MetadataStructureOptions.SystemSynonymImageIndex.
  • MetadataTreeOptions.SystemTablesImageIndex is renamed to MetadataStructureOptions.SystemTableImageIndex.
  • MetadataTreeOptions.SystemViewsImageIndex is renamed to MetadataStructureOptions.SystemViewImageIndex.
  • MetadataTreeOptions.UserProceduresImageIndex is renamed to MetadataStructureOptions.UserProcedureImageIndex.
  • MetadataTreeOptions.UserSynonymsImageIndex is renamed to MetadataStructureOptions.UserSynonymImageIndex.
  • MetadataTreeOptions.UserTablesImageIndex is renamed to MetadataStructureOptions.UserTableImageIndex.
  • MetadataTreeOptions.UserViewsImageIndex is renamed to MetadataStructureOptions.UserViewImageIndex.
  • MetadataTreeOptions.GroupingType is replaced with the MetadataStructureOptions.GroupBy* bunch of properties.
  • MetadataTreeOptions.HideSingleDatabaseNode is deleted. Use the MetadataStructureOptions.GroupByDatabases property to disable grouping by databases.
  • MetadataTreeOptions.SortingType is moved to DatabaseSchemaTreeOptions.SortingType.
  • MetadataTreeOptions.DefaultExpandLevel is moved to DatabaseSchemaTreeOptions.DefaultExpandLevel.
  • QueryBuilder.TreeFont is moved to DatabaseSchemaTreeOptions.Font.

The QueryBuilder.QueryStructureTreeOptions group:

  • QueryStructureTreeOptions.ExpandFieldsNodes is renamed to ExpandExpressionNodes.
  • QueryStructureTreeOptions.ExpandFromNodes is renamed to ExpandDataSourceNodes.
  • QueryStructureTreeOptions.FieldsImageIndex is renamed to ExpressionsNodeImageIndex.
  • QueryStructureTreeOptions.FromImageIndex is renamed to DataSourcesNodeImageIndex.
  • QueryStructureTreeOptions.FieldImageIndex is renamed to ExpressionImageIndex.
  • QueryStructureTreeOptions.FromObjImageIndex is renamed to DataSourceImageIndex.
  • QueryStructureTreeOptions.FieldsNodeText is renamed to ExpressionsNodeText.
  • QueryStructureTreeOptions.FromNodeText is renamed to DataSourcesNodeText.
  • QueryStructureTreeOptions.ShowFields is renamed to ShowExpressions.
  • QueryStructureTreeOptions.ShowFrom is renamed to ShowDataSources.

The QueryBuilder.LinkOptions group is moved to the BehaviorOptions:

  • LinkOptions.CreateLinksByIdenticalFieldNames is renamed to BehaviorOptions.CreateLinksByIdenticalFieldNames.
  • LinkOptions.CreateLinksFromRelations is renamed to BehaviorOptions.CreateLinksFromForeignKeys.
  • LinkOptions.LinkManipulations is renamed to BehaviorOptions.LinkManipulations.
  • LinkOptions.AddLinkedObjects is renamed to BehaviorOptions.AddLinkedObjects.
  • LinkOptions.DeleteUnusedObjects is renamed to BehaviorOptions.DeleteUnusedObjects.

The QueryBuilder properties moved to the BehaviorOptions group:

  • QueryBuilder.UseAltNames is moved to BehaviorOptions.UseAltNames
  • QueryBuilder.AllowSleepMode is moved to BehaviorOptions.AllowSleepMode.
  • QueryBuilder.LoadJoinsFromWhereClause is moved to BehaviorOptions.LoadJoinsFromWhereClause.
  • QueryBuilder.FilterTabsByActiveQueryPart is moved to BehaviorOptions.FilterTabsByActiveQueryPart.
  • QueryBuilder.ParsingErrorOnUnknownObjects is moved to BehaviorOptions.ParsingErrorOnUnknownObjects.

The QueryBuilder properties moved to the SQLGenerationOptions group:

  • QueryBuilder.ObjectPrefixSkipping is moved to SQLGenerationOptions.ObjectPrefixSkipping.
  • QueryBuilder.QuoteAllIdentifiers is moved to SQLGenerationOptions.QuoteAllIdentifiers.
  • QueryBuilder.AsKeywordInExpressionAlias is moved to SQLGenerationOptions.AsKeywordInExpressionAlias.
  • QueryBuilder.AsKeywordInObjectAlias is moved to SQLGenerationOptions.AsKeywordInObjectAlias.
  • QueryBuilder.InnerKeywordInLinks is moved to SQLGenerationOptions.InnerKeywordInLinks.
  • QueryBuilder.OuterKeywordInLinks is moved to SQLGenerationOptions.OuterKeywordInLinks.

The QueryBuilder properties moved to the DesignPaneOptions group:

  • QueryBuilder.SnapDiagramObjects is moved to DesignPaneOptions.SnapToGrid.
  • QueryBuilder.SnapSize is moved to DesignPaneOptions.GridSize.
  • QueryBuilder.LinkPainter is moved to DesignPaneOptions.LinkStyle.
  • QueryBuilder.DiagramPaneColor is moved to DesignPaneOptions.BackColor.

The QueryBuilder properties moved to the MetadataLoadingOptions group:

  • QueryBuilder.MetadataFilter is moved to MetadataLoadingOptions.MetadataFilter.

The QueryBuilder properties moved to the VisualOptions group:

  • QueryBuilder.FlatBorders is moved to VisualOptions.FlatBorders.
  • QueryBuilder.ShowTabIcons is moved to VisualOptions.ShowTabIcons.
  • QueryBuilder.TabsAlignment is moved to VisualOptions.TabsAlignment.
  • QueryBuilder.TabsAppearance is moved to VisualOptions.TabsAppearance.
  • QueryBuilder.TabsImageList is moved to VisualOptions.TabsImageList.

Various properties moved to the PanesConfigurationOptions group:

  • QueryBuilder.UnionNavBarVisible is moved to PanesConfigurationOptions.UnionNavBarVisible.
  • CriteriaListOptions.CriteriaListHeight is moved to PanesConfigurationOptions.QueryColumnsPaneHeight.
  • CriteriaListOptions.CriteriaListVisible is moved to PanesConfigurationOptions.QueryColumnsPaneVisible.
  • QueryStructureTreeOptions.TreeVisible is moved to PanesConfigurationOptions.RightTreePaneVisible.
  • QueryStructureTreeOptions.TreeWidth is moved to PanesConfigurationOptions.RightTreePaneWidth.
  • MetadataTreeOptions.TreeVisible is moved to PanesConfigurationOptions.LeftTreePaneVisible.
  • MetadataTreeOptions.TreeWidth is moved to PanesConfigurationOptions.LeftTreePaneWidth.

Changes in the QueryBuilder events:

  • QueryBuilder.CriteriaListControlInitialization is deleted. Use the ControlCreated event instead.
  • QueryBuilder.Filter* events are deleted. The new events to implement this functionality will be added to the MetadataContainer soon.
  • QueryBuilder.Get*ToolTipText events are deleted. The replacement events will be added soon.
  • QueryBuilder.DiagramObjectAdded is renamed to DataSourceAdded.
  • QueryBuilder.DiagramObjectAdding is renamed to DataSourceAdding.
  • QueryBuilder.DiagramObjectDeleting is renamed to DataSourceDeleting.

This page was: Helpful | Not Helpful