Is there LPL to presort list reports by specific fields? i.e. alphabetical by last name, start date, etc?
LPL on a List display field:
[sort order is (<SetName> | primary)] [is default [descending]]
E.g.EmployeeName sort order is ByEmployeeLastName*adding "is default" means it's the sort order when the list initilally displays vs. a user having to use the column to sort.
Also - In the UI both Personalize / Create Report allow for it at well:
Pick your "Set" (which is a physical DB index.
Once chosen you can see the Fields in the Set which dictates the order of the sorting. Here it's by Product then by ReleaseID.
Hi - I realized shortly after posting this that the issue was a bit more complex than what I had initially thought.
We created a business class called "FMLA" with a relation to the Employee business class.
I copied the "Set" LPL for "ByPresentationNameSnapshot" from the Employee business class and added it to the FMLA business class.
Then I went into the list report LPL and added the sort LPL