Active Query Builder  »  News  »  Active Query Builder ASP.NET Edition News

January 21, 2017

Active Query Builder ASP.NET Edition 2.13 lets add calculated fields by end-users.

We're glad to announce the new version of Active Query Builder ASP.NET Edition. You can evaluate the new version by requesting the trial. Customers can download the new version in the Customer's area.

What's new in the Active Query Builder ASP.NET Edition 2.13 since version 2.12?

  • The bug with datasouce popup menu not showing in IE has been fixed.
  • Ability to add new calculated fields by the end-user has been made. Now users can add new fields to database objects and specify custom SQL expressions for them. These can be fields intended to perform some manipulations on real database object fields (concatenation, "if - then" expressions, etc.) They can also be used to get values from lookup tables. Of course, the end-user must have the necessary knowledge of SQL language, so we recommend to turn this feature on only if you know that if will be valuable for your end-users.
  • Setting the new QueryBuilderControl.EnableUserFields property to true enables addition and removal of user-defined fields by the end-user.
  • The new validateCondition and validateExpression methods have been added to validate values for the Expression and Condition grid cells.
  • The new MetadataContainer.ExportUserFieldsToXML and ImportUserFieldsFromXML methods have been added to save and restore user-defined fields to a file. They let keep the user's work between work sessions.
  • The new User Fields demo has been added to demonstrate the new functionality.
  • The new "AllColumns" value can be applied to the UseCustomExpressionBuilder property of the Grid control. Setting it turns the possibility to edit values in both Expression and Condition column cells using the custom editor.
  • The new method QB.Web.Application.setUserData(data) has been added. The data passed to this method will be sent to the server within the next sync event.
  • A new row is now added to the Query Columns Grid on double click on a field in the Datasource field list, but it doesn't get checked. That allows for a quick addition of conditions for fields without having added them to the SELECT list.
  • Other minor bug fixes and improvements have been made.

Find the details and code samples for the functionality in this article. at ActiveDBSoft.

» All Active Query Builder ASP.NET Edition news

Comments by Disqus:




We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!

Social networks