0
 Followers
3
 Likes

Show all Aggregate functions in Group By for all fields

Aggregates & Queries
New

Please more completely associate available aggregate functions in Group By Aggregates. For example, MAX() is an available aggregate function to be used on text/varchar fields in SQL Server, but is not an option in the Aggregate editor on Text columns.

Additionally, please add all the options for aggregates, including MAX, VAR, COUNT DISTINCT, etc as indicated here:

https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-2017


I understand the desire to limit options that could cause an error. For example, if we chose AVG on a text field, we'd get "Operand data type nvarchar is invalid for avg operator." And that's OK. That's definitely MORE ok, than requiring us to go into an advanced SQL to get an AVG(). That's way more work and prone to error and increased maintenance if we change the data model.



For more see the original post regarding this issue:

https://www.outsystems.com/forums/discussion/41996/group-by-aggregate-give-me-maxcolumn-where-column-is-text/



Created on 7 Nov 2018
Comments (2)

Would indeed be nice additions.

Changed the category to Aggregates & Queries


views
181
Followers
0