Question Re: Sort items in input control in Technology Q&A

Sort items in input control

sapuser0001 — Tue, 16 Aug 2022 15:16:41 GMT

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.

Re: Sort items in input control

Former Member — Tue, 16 Aug 2022 15:17:18 GMT

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!

Re: Sort items in input control

VijayetaSharma — Tue, 16 Aug 2022 15:48:05 GMT

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

Re: Sort items in input control

sobhagyashri — Tue, 16 Aug 2022 15:59:14 GMT

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

Re: Sort items in input control

sapuser0001 — Wed, 17 Aug 2022 07:35:01 GMT

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.

Re: Sort items in input control

VijayetaSharma — Wed, 17 Aug 2022 13:52:41 GMT

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

Re: Sort items in input control

sapuser0001 — Thu, 18 Aug 2022 08:25:57 GMT

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.

Re: Sort items in input control

sapuser0001 — Thu, 18 Aug 2022 08:26:19 GMT

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

Re: Sort items in input control

avsalynin — Thu, 18 Aug 2022 08:47:11 GMT

sap.user0001

there are plans for 2023

Re: Sort items in input control

sandip_kumar003 — Thu, 29 Jun 2023 05:12:48 GMT

Hi,

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

Best Regards,

Sandip Kumar.

Re: Sort items in input control

SirishaKota — Wed, 16 Aug 2023 04:37:33 GMT

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.

Re: Sort items in input control

sandip_kumar003 — Wed, 16 Aug 2023 04:58:18 GMT

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.

Re: Sort items in input control

azadanalytics — Wed, 23 Apr 2025 14:55:33 GMT

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/