Active Query Builder support area

SQL function support

  • updated
  • Completed

A nice feature would be to have a drop down list of functions for the user to pick - we use DATEDIFF frequently for example but the user has to manually type this into the SQL box.

Andrey Zavyalov, PM
Thank you for your feedback.
We are going to embed the functionality of advanced SQL text editor into inline editor of Query Columns grid cells in one of the next versions.
Danilo Maini

Is it possible to know when this feature will be available?
What SQL Server functions might be available?

Andrey Zavyalov, PM

This function is available in the Professional version in the SQL Text editor control which is also used in Expression and Criteria cells of the Query Column Grid. You can upgrade to the Professional version for the price difference between these licenses.