Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
10 replies
Subscribers
9 subscribers
Views
4094 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi, I am using sorttextarray(pv!test, false) to sort a list of text
sathisht534
over 9 years ago
Hi,
I am using sorttextarray(pv!test, false) to sort a list of text array(username ie Frist name+ " "+Lastname), its not sorting text if it has a "." or just first name in the string is there anyway to fix this?, please do find the screenshot for the same below.
OriginalPostID-207497
OriginalPostID-207497
Discussion posts and replies are publicly visible
0
Paul Mayeur
Appian Employee
over 9 years ago
This is because they are lower case (k,l,s instead of K, L, S). It is sorting capitals before lowercase
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sathisht534
over 9 years ago
is there a way to fix that without changing the (k,l,s) to uppercase?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
@sathisht How about using sort()?
sort({"Tammy Page","Teresa Croce","kalpana.mayuluri","Thane S Thurmond","Thomas Zebovitz","Tina M Walker","VANAND","Vanee Komolprasert","Vivian M Gilliam","WTROTTER","Weifeng Li","kalpana.mayuluri","Ischlappal","sathish.thulukanam"}) => Ischlappal; kalpana.mayuluri; kalpana.mayuluri; sathish.thulukanam; Tammy Page; Teresa Croce; Thane S Thurmond; Thomas Zebovitz; Tina M Walker; VANAND; Vanee Komolprasert; Vivian M Gilliam; Weifeng Li; WTROTTER
FYI, reverse(sort()) gives you descending order.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sathisht534
over 9 years ago
no, sort() dint work , it does the same thing.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sanjays0006
over 9 years ago
We have a shared component for this :
forum.appian.com/.../summary
Try it once. I think this will solve your issue
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
@sathisht Would you please be able to elaborate on how you have been trying to implement the sorting? It has worked well for me, when I did a quick test in the expression editor.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sathisht534
over 9 years ago
I have a process variable(test) which can hold multiple text values retrieved and saved through a DB call ,then I tried to use "=sort(pv!test)" in the drop down
Note: I am using portal interface in 7.11 version appian
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
@sathisht Can you configure the attributes of Dropdown as follows and test once again:
Display Label: sort(pv!test)
Value: sort(pv!test)
I am assuming that pv!test holds {"Tammy Page","Teresa Croce","kalpana.mayuluri","Thane S Thurmond","Thomas Zebovitz","Tina M Walker","VANAND","Vanee Komolprasert","Vivian M Gilliam","WTROTTER","Weifeng Li","kalpana.mayuluri","Ischlappal","sathish.thulukanam"} and tested the usecase on the same assumption in portal form of 16.1.
That worked fine for me and the output was exactly as mentioned above by me. Still if this doesn't work, it would be good if you can attach a screenshot of Dropdown configuration in your form.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sathisht534
over 9 years ago
it worked , thanks @sikhivahans
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
Glad to hear that..!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel