Display the user list in alphabetical order by last name in the user picker field?

Question

Hi All, 
 I need to show the list of users using only the last name in alphabetical order. Users present in the environment. 
 how to display all the users using user picker field?

Mike Schmitt · Answer

I've built this using a Custom Picker field before, out of bare necessity. There are many pros and cons. Just off the top of my head... 
 Pros: 
 
 assuming you already have a "users" DB table in your application (which I always recommend anyway), you get a lot of extra inherent flexibility, for example... 
 you can set it to allow selection of deactivated users - especially useful if there are any admins / managers who need to pull tasks still assigned to users who've left your organization, since the OOB user picker is frustratingly useless for this use case 
 you can incorporate your own DB elements (if necessary) into the search - in my current system, for example, the user's PK ID is exposed to the end users as the "person ID" and used referentially. (I may have designed this a little differently myself, but it was given to me this way, and it's not bad overall). In other words, I can type parts of someone's name, username, and/or their Person ID into my custom picker field and it'll pull that person. 
 you have full control over formatting of the selection text (as in the plaintext it displays; it can't use Rich Text unfortunately). For example, "Firstname Lastname (username) [PersonId]" 
 you can have the selected entries function as links to items in the accompanying record (especially useful when you have a custom record type set up for your perosnnel data) 
 
 Cons: 
 
 maybe a tad slower than the OOB user picker (though i haven't extensively tested this lately) 
 useless for any Appian accounts not explicitly stored in the DB 
 if you need to use "group filter" functionality, it gets quite a bit slower and/or more tricky to implement 
 there's no way to mimic the nice "user picture card" thing you get in the OOB user picker