How to sort in alphabetic order
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2022 04:08 AM
In my catalog item i have 5 fields, User 1, User 2, User 3, User 4 and User 5.
I need these values in my Workflow, sort them in A to Z format. How to achieve this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2022 04:14 AM
Hello,
Use a run script activity and get all the variables access and push it to an array like below
var fd1 = current.variables.field1 back end name;
var fd2 = current.variables.field2 back end name;
var fd3 = current.variables.field3 back end name;
var fd4 = current.variables.field4 back end name;
var fd5 = current.variables.field5 back end name;
If its a reference field use current.variables.field back end name.getDisplayValue();
var arr=[];
arr.push(fd1);
arr.push(fd2);
arr.push(fd3);
arr.push(fd4);
arr.push(fd5);
var sortedArr = arr.sort();
you can access elements one by one which should be sorted in alphabetical order like sortedArr[0] ,sortedArr[1],......
Please mark my answer correct if it helps you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2022 04:29 AM
Tried this, But not getting this in log.
Last name is single line text field.
var arr =[];
var fd1 = current.variables.FND_RecLastName;
var fd2 = current.variables.last_name_2;
var fd3 = current.variables.last_name_3;
var fd4 = current.variables.last_name_4;
var fd5 = current.variables.last_name_5;
arr.push(fd1);arr.push(fd2);arr.push(fd3);arr.push(fd4);arr.push(fd5);
var sortedArr = arr.sort();
gs.log("sortedArr"+sortedArr);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2022 04:35 AM
hello,
Can you try putting logs for arr
gs.info('before sorting'+arr);

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2022 04:42 AM
Try converting the array back to string?