AnsweredAssumed Answered

Sorted list of values over join table

Question asked by malauch on Mar 10, 2018
Latest reply on Mar 12, 2018 by malauch

I have problems with generating lists of values with correct sort order. I have 2 tables joined with additional join table.

 

Location ------< JoinTable >------ Parameters

 

Locations

IDName
1city
2village
3forest

 

JoinTable

IDlocationIDparametercustomOrder
113
121
132

 

Parameters

ID
Value
1Some value
2Another value
3Diffrent value

 

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
2Another value
3Diffrent value
1Some 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.

Outcomes