How to "Order By" a runtime column with the "List_SortColumn" widget?

I have a runtime column in an aggregate query and I would like to sort them with the List_Sort widget, but when I fill the field "Column" in the widget with "{table}.[runtime column]", in runtime give the error that the column doesn't exist.

Can you post your query (at least the select portion) and the column you are trying to sort on?

Hi Izak,

I submit an image that show the three columns that I use, the first one (Media) is the column that I want to Sort with the widget, the other 2 (Valor and Peso) on the right are the base columns that I use to create the first one. I can sort with the widget every column except the first one.

One way will be to create a attribute on that entitie where you save the value of Media.

Cheers

Hi great friend Alberto!

That's an option...when I structured the database didn't thought on that attribute for the entity, because it would be possible to calculate later on runtime, but now it's an option yes ;) I have only to create an action with "for each" and calculate/set that value to that entity attribute.

This same question recently came up during a training session. Glad to know someone had already been on top of it :) Anyway, we also found out that using the name of the calculated attribute worked just fine for the Aggregate Sorting. In the image below, Duration is the calculated attribute.