In yesterday's focus group meeting we briefly touched on the inability to sort lists on some Infor standard/delivered fields.
If you've faced this yourself, and if you can recall the details, we would love to know where in the application this was, namely which BusinessClass and List plus which Field/Column you couldn't sort on.
This issue breaks down to me as:
a. Set is missing and we need to deliver that Set if possible (potentially including the capability on the List as well)
b. Set exists but the Personalization, etc tooling doesn't make it obvious or easy enough to expose it on the List
As always, any information or intel is appreciated!
Some techy side notes:
A "Set" is essentially a physical index at the database level. It essentially specifies the order in which data should come back and allows the query at a DB level, which is performant. Here a few examples from Position from HRT:
ByJob
Sort Order
HROrganization
Job
Position
ByJobDescription
Sort Order
HROrganization
Job.Description
Job.ShortDescription
Job
Position
ByPositionLevel
Sort Order
HROrganization
PositionLevel
ShortDescription
Position
ByPositionFamily
Sort Order
HROrganization
PositionFamily
ShortDescription
Position
On List columns then you can use these Sets, like so:
Job.Description
label is "JobDescription"
sort order is ByJobDescription
This allows a sort on the Job Description column on this List by:
HROrganization
Job.Description
Job.ShortDescription
Job
Position
In Excel the equivalent would look like this:
