When I create a multi box, showing Name, but ordering by the expression NameSortOrder, this doesn't seem to work. Iam hoping to see '- Commercial Subgroup' between '-- Commercial' and '-- Insurance' , instead it appears at the end of the list.
Thanks Erich, that seems to work better. However it presents another issue. In my little test app with an inline load, this is fine. However in my real app I won't know what items to expect and could do with generating a sort order based on the text field. Any ideas how to achieve this?
Unfortunately this didn't quite work in my QVW, or at least it won't work until I rework the data.
Consider this inline load
load * inline [
Name, SortOrder, %Key
'--- Global', 1, 1
'-- Commercial', 2, 1
'-- Insurance', 4, 1
'- Commercial Subgroup',3, 1
'--- Global', 1, 2
'-- Commercial', 2, 2
'-- Insurance', 4, 2
'- Commercial Subgroup', 3, 2 ];
I have now added a field %Key, which I'm going to use to link to another table. Now, having build a Name multi box, ordered by expression 'SortOrder', when no Name is selected the list is ordered correctly. But when I select a Name, the list is no longer sorted.
I have reported this and it has been acknowledged as a bug.