3
 Followers
21
 Likes

Improve conversion of Aggregate to SQL

Aggregates & Queries
New

Since a while now, it's possible to convert an Aggregate to an SQL query. This is a great feature, but it has a number of limitations. For one, discoverability is low. Why not add it to the context menu when clicking an Aggregate?

Secondly, the limitations listed are annoying, if Service Studio can run the query on the database, it should be able to convert it to SQL. The limitations listed:

The option to convert an Aggregate to a SQL element will only be available if your Aggregate doesn't include:

  • Structures in Sources
  • Calculated Attributes
  • Group By attributes
  • Dynamic Sorts

It would be nice if this feature would be improved, so that all (or most) of these limitations are gone.

Created on 24 Sep 2020
Comments (1)

Good Ideia!

I created an idea about show real value in advanced query, see here if you agree.
tnks.

views
347
Followers
3