Question
Knowledge Experts SA
FR
Last activity: 16 Oct 2018 12:03 EDT
Alphanumeric Order
We need to have in Pega an alphanumeric ordering for some properties
For some DropDown or autocomplete properties (using reportDefinitions or Data page as data source), we need to sort them according to an alphanumeric order.
***Updated by moderator: Lochan to add Categories***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Areteans
AU
How about you sort the column that is being the source for the drop down / Auto complete? Once you set a sort on the column in the report definition rule, the data that form the source for these DD / Auto complete, will get sorted automatically as they are getting displayed.
Hope this helps.
Knowledge Experts SA
FR
Hi ,
I am using a sort on the coulumn on report definition as shown in the attachment(see alphanumeric2.png) but i get the following order (see alphanumeric1).
I want for example to get V3.1.31.2.of before v3.1.31.12a.en and v3.1.31.16.of.
Is it possible ?
Thanks
Areteans
AU
Your expectation is a custom sort.
As per the screen shot you are getting the result in ascending order only since V3.1.31.2.of is a great number than V3.1.31.12a.en (.2 > .16) .
Knowledge Experts SA
FR
Hi ,
Is there any way to custom this order or to create an sql function to add to the report?
Thanks.
PEG
GB
The behaviour which you are describing is the normal sort for a text field.
When sorting text, implied blank padding sorts ahead of any other character, so "V.31" will sort ahead of "V.31.x".
Also, since the value is text, numbers in the string are also considered as text, so "V31.45" sorts ahead of "V31.5" (because "4" sorts ahead of "5").
You are expecting that the numeric values be sorted in ascending numeric value, such that 5 sorts ahead of 45.
What you are describing is the need for a custom sort to sort the values for this property partially as text and partially numerically.
You need to create a custom sort which will break the value of the property into its respective parts and sort each of the parts working right to left (minor to major sort), appropriately as text or numbers, to arrive at the sort order which you are describing.
Once your custom sort is created and defined in a library that you have added to your ruleset, you then need to use the Override Sort Function field on the property's Advanced tab to specify the name of your custom sort.
NCS Group
SG
Even Windows know how to sort alphanumeric text correctly.
Who would put v.31.4 in front of 31.40 instead of 31.5. Don't tell us it's intended behavior, it's a bug, a bug, a bug!