I have problems with generating lists of values with correct sort order. I have 2 tables joined with additional join table.
Location ------< JoinTable >------ Parameters
Relation between TOs Locations and JoinTable is sorted by field JoinTable::customOrder and in portal it works great. So it looks like that:
Portal based on JoinTable on first record of Locations table
|ID parameter||Parameter Value|
However, when I use List ( Parameters::Value ) function in calculation from Locations table result is unsorted (is like that "Some value¶Anoter value¶Different value"). The sorting defined on Relation Graph between Location TO and JoinTable TO doesn't work in that case.
What is the best solution to get list of Parameters::Value from Location TO but sorted via JoinTable::customOrder? I can solve that by creating unstored calculation field in Parameters table, which is just grabbing value of JoinTable::customOrder and then sorting relation by that field. However, I don't like creating of unstored field and I wonder if there is some better solution. EDIT: Obviously creating that calculation field doesn't work either.