Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]Welcome to DevExpress .NET Documentation
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical Grid
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]Scheduler
  [Expand]HTML Editor
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Collapse]Query Builder
   [Expand]Getting Started
   [Collapse]Visual Elements
     Query Builder Toolbar
     Design Surface
     Selection Properties Panel
     Tables List
     Data Preview
     Select Statement Preview
    Binding to Data
    Obtaining the Resulting Query
    Localize the Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Selection Properties Panel

The Selection Properties Panel provides access to all settings available for the currently selected data table, data column or relation.

Expanded Table Properties

Clicking a table within the Query Builder design surface will display the table properties.

The following properties are available:

  • Name

    Indicates the table name by which it is referred to in the database.

  • Alias

    Specifies a custom table name (alias).

Expanded Column Properties

Clicking a data column of a table or view will display the data column properties.

The following properties are available:

  • Name

    Indicates the column name by which it is referred to in the database.

  • Type

    Indicates the type of data contained in the column.

    String columns are provided with information about the maximum string length.

  • Alias

    Specifies a custom column name (alias).

    This option is available only for columns that are included into a query.

  • Output

    Specifies whether or not the column is included into the query result set.

  • Sort Type

    Specifies whether to preserve the original order of data records within the column, or sort them (in an ascending or descending order).

  • Sort Order

    This option becomes available after applying sorting to the data column's records.

    It defines the priority in which sorting is applied to multiple columns (the less this number is, the higher the priority).

    For example, if column A has the sort order set to 1 and column B has it set to 2, the query will be first sorted by column A and then by the column B.

    Changing this setting for one column automatically updates the sort order of other columns to avoid conflict of priorities.

  • Group By

    Specifies whether or not the query result set should be grouped by this column.

    Note

    Grouping and/or aggregation can only be applied to each of the selected columns.

  • Aggregate

    Specifies whether or not the column's data records should be aggregated.

    The following aggregate functions are supported: Count, Max, Min, Avg, Sum, CountDistinct, AvgDistinct, SumDistinct.

    Applying any of these functions to a column will discard individual data records from the query result set, which will only include the aggregate function result.

    Note

    Use aggregation/grouping either for all selected columns or for none of them. Applying the aggregation to one column automatically applies grouping to other selected columns. If you remove all aggregation functions, grouping against other columns will be reset as well.

Expanded Relation Properties

Clicking the data relation will display the corresponding properties that define the join type (Inner or Left Outer) and applied logical operator.

A left outer join returns all the values from an inner join along with all values in the "left" table that do not match to the "right" table, including rows with NULL (empty) values in the key field.

When the left outer join is selected, the relationship line displays an arrow pointing at the "right" table of the join clause.

After executing the query, it will return a "flat" table composed of data records selected based on the specified join options.

Expanded Query Properties

Clicking the Query Builder surface will display the query properties.

The following properties are available.

  • Name

    Specifies a custom query name (alias).

  • Filter

    Runs the Filter Editor dialog where you can specify filter criteria against which the query result set should be narrowed down.

  • Group Filter

    Runs the Filter Editor dialog where you can specify filter conditions for grouped and aggregated data. If data is not grouped, this option is disabled.

  • Select All (*)

    Specifies whether or not the query result set should include all columns from the selected tables and/or views, regardless of their individual settings.

    This option is set to No by default.

  • Select distinct

    Specifies whether or not only distinct values should be included into the result set.

    This option is set to No by default.

Is this topic helpful?​​​​​​​