I have a series of instances of a BO
Each BO will have a relationship to a classification
BORecord has peer single to BOClassification
BOClassification has attributes
Code, and
Name
Examples might be
Code Name
10 Home
20 Export
When I create the BORecord instances I then want to show them grouped in a query
I can use a short cut on the BORecord to put the Name of the Classification into the query and then group the query on that shortcut, however, the relevance for sorting is based on the Code number
The challenge is that if I group on the shortcut of the Classification Name, Export will come before Home (this simple example I could just reverse the search order, however the real world example has multiple codes and names and they are not sortable alphabetically in a meaningful way) Where possible I'd like to not expose the Code as it is not user meaningful,
I suppose I could put the code and Name into a text field and then sort on that but this is not desirable. Does anyone have any suggestion?
