Aggregate - sorting by a calculated column

Aggregate - sorting by a calculated column

  
Hi,

it is explicitly stated in the documentation that the Aggregate widget can sort by calculated columns. But when I provide dynamic sorting:

List_SortColumn_GetOrderBy(MyTable.Id, "")

and List_SortColumn_GetOrderBy returns the name of such a column (e.g. "MyColumn"; it is just a concatenation of two test columns), I get a runtime error:

Invalid column name 'MyColumn'.

Is there something I don't know about?

Regards
Tomasz
Hi Tomasz,

There was a bug that prevented this from working in early versions. What version are you using?
Hi,
The newest one - 9.0.1.16 (I mean ServiceStudio).

Regards
Tomasz
What about the Server?

SQL Server 2008 R2

I've prepared a simple example. Maybe it'll help. Just open the Aggregate and try to see test values.

Regards
Tomasz
Sorry Tomasz,

I ment the Platform Server... You can validate this by going to the environment management console (http://yourserver/ServiceCenter). After you login you'll see a box to the right that indicates the Platform Server version.
:-)
9.0.1.4
Hi Tomasz,

The fix was introduced in version 9.0.1.9:
  • Fixed dynamic order by to work with calculated attributes (#854718)