ActiveQueryBuilder.View.WPF 3.2.0.1029

.NET Framework This package is compatible with all versions of .NET Framework.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package ActiveQueryBuilder.View.WPF --version 3.2.0.1029
NuGet\Install-Package ActiveQueryBuilder.View.WPF -Version 3.2.0.1029
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="ActiveQueryBuilder.View.WPF" Version="3.2.0.1029" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add ActiveQueryBuilder.View.WPF --version 3.2.0.1029
#r "nuget: ActiveQueryBuilder.View.WPF, 3.2.0.1029"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install ActiveQueryBuilder.View.WPF as a Cake Addin
#addin nuget:?package=ActiveQueryBuilder.View.WPF&version=3.2.0.1029

// Install ActiveQueryBuilder.View.WPF as a Cake Tool
#tool nuget:?package=ActiveQueryBuilder.View.WPF&version=3.2.0.1029

Visual SQL Query Builder for WPF that lets users build ad-hoc SQL queries with sub-queries. Active Query Builder has full support of all popular database servers and appropriate SQL dialects. The end-user can combine visual query building with direct SQL query text editing. SQL text editor with code completion and syntax highlighting satisfies the needs of professional query writers.

Product Compatible and additional computed target framework versions.
.NET Framework net is compatible. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
3.11.3.2252 98 4/22/2024
3.11.2.2251 139 3/23/2024
3.11.1.2250 114 3/22/2024
3.11.0.2249 143 3/13/2024
3.10.0.2248 504 12/14/2023
3.9.14.2246 376 12/13/2023
3.9.13.2245 546 9/11/2023
3.9.12.2244 691 5/31/2023
3.9.11.2243 654 5/15/2023
3.9.10.2242 696 4/26/2023
3.9.9.2241 713 4/13/2023
3.9.8.2240 746 3/10/2023
3.9.7.2239 733 2/18/2023
3.9.6.2238 830 1/4/2023
3.9.5.2237 893 10/24/2022
3.9.4.2236 885 9/20/2022
3.9.3.2235 926 9/10/2022
3.9.2.2234 953 8/29/2022
3.9.1.2233 939 8/21/2022
3.9.0.2232 1,005 7/15/2022
3.8.30.2231 971 7/15/2022
3.8.29.2230 995 7/5/2022
3.8.28.2229 895 7/1/2022
3.8.27.2228 949 6/28/2022
3.8.26.2227 948 6/17/2022
3.8.25.2226 984 6/2/2022
3.8.24.2225 1,005 5/13/2022
3.8.23.2224 963 5/6/2022
3.8.22.2223 1,011 4/28/2022
3.8.20.2222 1,006 4/22/2022
3.8.19.2221 970 4/21/2022
3.8.17.2219 1,021 2/16/2022
3.8.16.2218 982 1/26/2022
3.8.15.2217 822 1/13/2022
3.8.15.2216 1,009 1/13/2022
3.8.14.2212 876 12/9/2021
3.8.13.2211 902 12/8/2021
3.8.12.2210 929 11/10/2021
3.8.11.2209 937 11/1/2021
3.8.10.2208 940 9/22/2021
3.8.9.2207 943 8/31/2021
3.8.8.2206 908 8/13/2021
3.8.7.2205 931 7/20/2021
3.8.6.2204 960 7/12/2021
3.8.5.2202 968 6/23/2021
3.8.5.2201 1,000 6/23/2021
3.8.4.2200 946 6/21/2021
3.8.3.2198 996 6/12/2021
3.8.2.1198 1,000 5/27/2021
3.8.1.1197 1,009 5/20/2021
3.8.1.1196 1,013 5/20/2021
3.8.0.1195 991 5/19/2021
3.7.18.1193 979 3/26/2021
3.7.17.1192 1,006 3/18/2021
3.7.16.1191 1,014 3/10/2021
3.7.15.1190 1,041 3/3/2021
3.7.14.1189 1,042 2/15/2021
3.7.13.1188 1,024 2/2/2021
3.7.12.1187 1,036 1/29/2021
3.7.11.1186 1,087 1/20/2021
3.7.10.1185 1,062 1/13/2021
3.7.9.1184 1,068 1/2/2021
3.7.8.1183 1,051 12/30/2020
3.7.7.1182 1,116 12/14/2020
3.7.6.1181 1,061 11/26/2020
3.7.5.1179 1,127 10/28/2020
3.7.4.1178 1,058 10/22/2020
3.7.2.1175 1,369 9/8/2020
3.7.1.1174 1,098 8/28/2020
3.7.0.1173 1,084 8/27/2020
3.6.15.1172 1,133 8/21/2020
3.6.14.1171 1,215 8/11/2020
3.6.13.1170 1,255 8/6/2020
3.6.12.1169 1,177 8/5/2020
3.6.11.1168 1,147 8/4/2020
3.6.10.1167 1,212 7/27/2020
3.6.9.1166 1,177 7/12/2020
3.6.7.1165 1,116 7/2/2020
3.6.6.1164 1,167 6/26/2020
3.6.5.1163 1,158 6/10/2020
3.6.3.1162 1,137 6/1/2020
3.6.2.1161 1,136 5/15/2020
3.6.1.1160 1,260 5/8/2020
3.6.0.1159 1,279 4/5/2020
3.5.40.1158 1,153 3/20/2020
3.5.39.1157 1,154 3/8/2020
3.5.38.1156 1,211 2/28/2020
3.5.37.1155 1,137 2/14/2020
3.5.35.1153 1,266 1/13/2020
3.5.34.1152 1,226 12/31/2019
3.5.34.1151 1,260 12/30/2019
3.5.33.1150 1,187 12/10/2019
3.5.32.1149 1,243 11/22/2019
3.5.31.1148 1,184 11/22/2019
3.5.30.1147 1,239 11/11/2019
3.5.29.1146 1,208 11/1/2019
3.5.28.1145 1,179 10/29/2019
3.5.27.1144 1,215 10/22/2019
3.5.26.1143 1,237 10/11/2019
3.5.25.1142 1,258 10/1/2019
3.5.25.1141 1,300 9/25/2019
3.5.25.1140 1,296 8/21/2019
3.5.24.1138 1,292 8/2/2019
3.5.22.1136 1,280 7/11/2019
3.5.21.1135 1,295 6/27/2019
3.5.21.1134 1,292 6/26/2019
3.5.20.1133 1,304 6/2/2019
3.5.19.1132 1,270 5/28/2019
3.5.19.1131 1,314 5/27/2019
3.5.18.1130 1,279 5/24/2019
3.5.17.1129 1,335 5/23/2019
3.5.16.1128 1,275 5/13/2019
3.5.15.1127 1,337 4/30/2019
3.5.14.1126 1,308 4/12/2019
3.5.13.1125 1,337 3/12/2019
3.5.13.1124 1,287 3/8/2019
3.5.12.1123 1,375 2/22/2019
3.5.12.1122 1,447 2/14/2019
3.5.12.1120 1,421 2/6/2019
3.5.12.1119 1,430 2/5/2019
3.5.8.1115 1,426 12/18/2018
3.5.6.1113 1,426 11/29/2018
3.5.6.1112 1,444 11/26/2018
3.5.5.1110 1,483 11/1/2018
3.5.4.1109 1,482 10/19/2018
3.5.4.1108 1,522 10/17/2018
3.5.3.1106 1,515 9/19/2018
3.5.2.1105 1,551 9/12/2018
3.5.1.1104 1,527 9/3/2018
3.5.0.1103 1,645 8/20/2018
3.4.21.1102 1,584 8/17/2018
3.4.20.1101 1,658 7/13/2018
3.4.19.1100 1,675 7/4/2018
3.4.19.1099 1,598 6/29/2018
3.4.18.1097 1,651 6/21/2018
3.4.16.1093 1,715 5/28/2018
3.4.13.1090 1,648 5/8/2018
3.4.12.1089 1,643 5/7/2018
3.4.11.1088 1,612 4/23/2018
3.4.8.1085 1,845 4/2/2018
3.4.7.1084 1,718 3/7/2018
3.4.6.1083 1,671 3/3/2018
3.4.5.1082 1,546 2/19/2018
3.4.3.1078 1,675 1/26/2018
3.3.25.1073 1,731 12/14/2017
3.3.24.1071 1,649 11/27/2017
3.3.20.1066 1,654 9/22/2017
3.3.16.1063 1,612 8/14/2017
3.3.12.1060 1,676 7/10/2017
3.3.11.1059 1,672 6/28/2017
3.3.10.1057 1,672 6/19/2017
3.3.9.1056 1,618 6/13/2017
3.3.8.1055 1,688 6/5/2017
3.3.7.1054 1,679 6/5/2017
3.3.6.1053 1,664 4/28/2017
3.3.6.1042 1,683 4/26/2017
3.3.3.1039 1,709 3/23/2017
3.3.2.1038 1,692 3/17/2017
3.3.0.1036 1,800 2/27/2017
3.2.2.1035 1,660 1/30/2017
3.2.1.1033 1,740 12/22/2016
3.2.1.1032 1,714 12/9/2016
3.2.1.1031 1,825 11/25/2016
3.2.0.1030 1,678 10/31/2016
3.2.0.1029 1,777 10/27/2016
3.1.1.1028 1,768 9/7/2016
3.1.1.1025 1,694 8/18/2016
3.1.1.1024 1,736 8/8/2016
3.1.1.1022 2,080 7/26/2016
3.1.1.1020 1,750 6/23/2016
3.1.0.1018 1,782 5/12/2016
3.1.0.1017 1,769 5/11/2016
3.1.0.1014 1,681 5/5/2016

+ The QueryBuilder control has got the new controls as dockable panels located to the left or right of the Design Pane.
+ The new the Sub-query Navigation Bar has been made. It was formerly available as a pop-up window of the Query Navigation Bar. (Available as a separate control in the Professional subscriptions only)
+ Usability of the Sub-query Navigation Bar is improved: now you can change the order of union sub-queries using drag'n'drop.
+ The new Properties Bar allows you to set various query, datasource and link properties without the need to open a dialog window. (Available as a separate control in the Professional subscriptions only)
+ The new Dock Manager control has been added. (Available in the Professional subscriptions only)
+ The new properties have been added to the QueryBuilder.PanesConfigurationOptions: SubQueryNavBarEnabled, PropertiesBarEnabled, SubQueryNavBarDockOptions, PropertiesBarDockOptions. The two latter property groups determine the initial state of appropriate sidebar panels and contain the following properties: AutoHide (True/False), Position (Left/Right).
+ The new property QueryBuilder.DockPanelsLayoutXML has been made to save the layout of sidebar panels between work sessions.
+ The new properties have been added to the QueryBuilder.VisualOptions to define colors and font of sidebar panels and its docking system.
= The Query, Datasource, and Link Properties dialogs are redesigned.
+ Query Transformer is now capable of renaming output query columns.
+ The new QueryTransformer.RenameDuplicatedColumns property prescribes to explicitly specify all the columns in the query SELECT list by expanding the asterisk items, then find and rename the unnamed and duplicated column names (default = false).
+ The new QueryTransformer.AlwaysExpandColumnsInQuery instructs to perform asterisk expansion in the query SELECT list even if it's not needed for the specified query transformations (default = false).
! The OutputColumn.Name property has been renamed to OriginalName.
+ The new OutputColumn.PreassignedName allows specifying the needed name for a query output column.
+ The new OutputColumn.ResultName gets the result query columns name, which turned out as a result of automatic columns renaming routine and manual appliance of the new name specified via the PreassignedName property.
+ Localization in the separate controls mode has been fixed.
= The QueryBuilder.Language and QueryView.Language properties are reflections for the global ActiveQueryBuilder.Core.Helpers.Localizer.Language property.
= Batch query column items processing on grouping on/off has been made.
- QueryTransformer: The bug with incorrect ORDER BY generation if column alias is the same as field name has been fixed.
= QueryTransformer: The new SQLGenerationOptions property has been added, the SQLBuilder property has been removed.
= The InvalidOperationException is thrown now if both MetadataItem.MetadataName and MetadataItem.MetadataObject properties are specified.
- The bug on resizing QueryColumnList control if cell editor is active has been fixed.
- The bug with not displaying fields from derived tables in the Expression Editor's tree has been fixed.
+ PostgreSQL: Support of custom aggregate functions has been made.
- MS SQL Server: CHAR and NCHAR, ROW and ROWS are added to the list of valid identifiers.
- Firebird: The simple form of the TRIM function is supported now.
- Oracle: Special form of the TRIM function is supported now.
- Localization in the separate controls mode has been fixed.