Does anyone know of a way to create a custom sort order on a delivered business class? Example: AchievementType has only three sort orders (ByUniqueID, By_UpdateStamp, and SymbolicKey), there's no option for by Achievement Type or description, etc.
The only way I know to sort live lists is by sets. These sorts available in the UI are the basic sets provided for each business class. There are no set configuration options for delivered business classes.
The symbolic key for the AchievementType is the AchievementType type field. In this case, a possible workaround would be to define the key for each so sorting by symbolic key would present the same order as a sort on the Description. If you have a multilingual organization, this may not be a good option as the Description field is translatable and depending on your business requirements, this order may need to vary by language.
Hi, thanks for confirming what I assumed. I think the workaround will suffice for now; my concern being if we ever need to change that order, we won't be able to as it'll be locked in by the AchievementType/symbolic key and once those types start being used on EmployeeAchievement we won't be able to change. Thank you!
An ER to Infor to ask for the Set you want is an option.
More aggressive option is adding a replication set into columnar where you can sort by ANY field you replicate, including Derived or User Fields.
