Sort items in input control

[sapuser0001]

How can I sort items in input control in alphabetic order?

I need to select "all members" are the input control as the options are supposed to be updated quite frequently when needed.

Thanks a lot.

[Former Member]

Welcome to the SAP Community. Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Now for some specific suggestions on how you might improve your question:

* Outline what steps you took to find answers (and why they weren't helpful) -- so members don't make suggestions that you've already tried.

* Share screenshots of what you've seen/done (if possible), as images always helps our members better understand your problem.

Should you wish, you can revise your question by selecting Actions, then Edit.

The more details you provide (in questions tagged correctly), the more likely it is that members will be able to respond. As it stands, I don't know if there is enough information here for members to understand your issue. So please consider revising your question because I'd really like to see you get a solution to your problem!

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

[sobhagyashri]

Hi,

There is no option available to sort alphabetically in SAC. But you can customize the sorting. When you right click on sorting there is option to chose custom order. You can define your own order instead of default.

Thanks and Regards

Shri

[sapuser0001]

OK, thanks for the answer. I really hope this feature can be implemented asap.

[VijayetaSharma · Accepted solution]

Hello sap.user0001.

Unfortunately there are no shot options available when it comes to input control. This is a limitations-

https://userapps.support.sap.com/sap/support/knowledge/en/2629045

What worked for me is, if I need to short alphabetically (acceding) on text, I select text / description and display them, If I need to short on key I select key as the first and default column and system auto short them. Key here is the first column in input control. System consider that column for auto short.

When you select all. System auto select all future new entries as well.

Don't forget to up-vote and accept, if it helped. 🙂

Thanks,

Vijayeta

[sapuser0001 · Accepted solution]

Hi vijayeta.sharma,

By "text / description", do you mean to play with "ID" or "description" of "Edit Input Control" as shown in the figure?

If so, I cannot quite get the trick you suggested. I would be very much appreciated if I can be instructed and taught more precisely. Really thanks.

[VijayetaSharma · Accepted solution]

Based on your screenshot it seems like you are trying on Hierarchy. Shorting on filter do not work on hierarchies.

As mentioned in my previous post, shorting is not available out of the box. Workaround works on first column (flat structures only).

Hope this answers your question.

Thanks,

Vijayeta

[sapuser0001 · Accepted solution]

OK, thanks for the answer. I do hope SAP can address this issue asap. After all, this is a rather straight-forward feature in the eyes of users that are expected to be delivered by default.

[avsalynin]

sap.user0001

there are plans for 2023

[azadanalytics]

Hi, you can do sort and custome sort in SAP analytics cloud, please see the detail steps here

https://sactutorial.com/custom-sort-in-sap-analytics-cloud/

[sandip_kumar003]

Hi,

The option for Input control is now available in the "Optimized Design Experience" story

Best Regards,

Sandip Kumar.

[SirishaKota]

Hi Sandeep,

Is there any thing that needs to be enabled on the behind to see the sort option? I am not seeing this option. I am trying to sort in a Story report.

Thanks

Sirisha.

[sandip_kumar003]

Hi Sirisha,

You just need to create that story in "Optimized Design Experience" mode.

Pic: When we start creating a story we need to choose the designing mode

because sorting the input control is only available in "Optimized Design Experience".

Best Regards,

Sandip Kumar.