I have the following Object in memory.

EmployeeEntity.PrSalaryAccountCollection

Each PrSalaryAccount has a PayTypeId. Which relates to a PayTypeEntity with the following fields. (Id, Code, Description, PrintOrder)

Each PrSalaryAccount has a GLAccountId. Which relates to a GLAccountEntity with the follwing fields. (Id, AccountNumber, Description)

When I load my grid with the EmployeeEntity.PrSalaryAccountCollection the users want them sorted in the following order. (All ascending)

PayTypeEntity.PrintOrder PayTypeEntity.Code GLAccountEntity.AccountNumber EmployeeEntity.PrSalaryAccount.Id

Using Self Service.

Thanks

Dan

Hi Dan,

In the Designer, you can edit the PrSalaryAccount & add those fields needed for sorting as Fields On Related Entities.

If fields needed for sorting are not on a directly related entity (ie, they are 2 or more relations away) - then you will need to simply create calculated readonly properties in a partial class for PrSalaryAccountEntity.

Then, to sort - use EntityProperty("field name"). So:

Dim myCalculatedField As New EntityProperty("field name")

Dim mySorter As New SortExpression
mySorter.Add(myCalculatedField)

Hope this helps!

Ryan

Additional info: http://llblgen.com/TinyForum/Messages.aspx?ThreadID=14843&StartAtMessage=0&#82752 http://llblgen.com/TinyForum/Messages.aspx?ThreadID=11125 http://llblgen.com/TinyForum/Messages.aspx?ThreadID=8363