Hello!

I have defined a typed list which contains an aggregate field, count distinct. Now, I'm trying to retrieve that typed list with the data sorted by that aggregate field. I have been trying to create a SortClause, but that requires an entity field, whereas my field is only defined for the typed list.

Thank you!

Please show us your code and the approximate results you want to achieve.

Hello!

I have a table, for example, Person: Id FirstName LastName CountryId

And I create a typed list in LLBLGen, PersonTypedList: NumberOfPeople - as an aggregate field: Count(Id) CountryId

And in my code I'll have something like this:

PersonTypedList typedList = new PersonTypedList();

IRelationPredicateBucket bucket = typedList.GetRelationsInfo();

GroupByCollection groupBy = new GroupByCollection();
groupBy.Add(PersonFields.CountryId);

ISortExpression sorter = new SortExpression();
//and this is where i want to add a sort clause to order by the NumberOfPeople field.

Is this achievable in this way? Or is there another method? Thank you!

You should use Sorting on Expressions. This documentation link is for EntityCollections, but it should work with your TypedList as well.