Sorting items by code or name in number lists

AnaplanIdeas

Description of the enhancement:

New items are added at the bottom of a list or at the bottom of a node when there is a Parent.

 

How this enhancement will improve you processes:

Re-ordering or sorting a list is a one-by-one manual operation that can be time consuming. 

AnaplanIdeas

Status changed to: Delivered

annejulie

Spoiler

Enable alphabetical sort on Lists - today, the only workaround is to export as flat file, sort and reimport

If we can expand this to alpha-sort on Line items, Module names, Dahsboard names, Actions, ... this would be even better.

Miran

Status changed to: Delivered

Rebecca

Status changed to: Delivered

andres.ayon

You can create a line item that applies only to the list you want to sort, using the formula "item(list)" and sort the module based on this column, however this has to be done in all the modules that have the list as a dimension. Having the option to directly sort the list would be much better. 

jeremie.colonna

It would be really usefull to be able to define sort criteria at a list level, based on properties of the list, and apply it to every module using the list (unless another sort is defined at a view level)

sean_culligan

Just a note on this issue. Although a little fiddly there is a workaround to do a one-off sort of list items. If you export the records, then sort them in excel. You can then go back to the list, and if you paste the records back into the insert menu (sorted) these will then re-sort in the list. 

 

This works if you are not using a numbered list. 

 

That said the sort functionality would be a helpful change, however I wanted to get this workaround up as it may save someone a fair whack of grunt work.

 

kr

Sean

Rebecca

Status changed to: Delivered

nick_barker

Two requests firstly to be able to sort a list and then the second I would like to be able to create Sort Keys for a list and then be able to choose which of these keys I would like to use to display my list. So the natural sorting would be ascending or descending based on name however it may be that I would like to create a sort key to display items in a specific order for one type of report and in another for a different report. By being able to define different sort keys for a list (I know this is creating a list property but needs must) and then being able to define this as a sort this would achieve this aim. The default sort method would be name (ascending or descending) but another sort method could be code for instance.

Miran

Status changed to: Delivered

PaulRitner

This would be very helpful.

 

swoods93

This would be very helpful, and I would particularly like to be able to sort the Users list (as has previously been discussed elsewhere on these forums). 

 

Also, as long as we're sorting lists, let's be able to do this on any column, not just alphabetical order. For example, I would like to sort by Users list by name... or by email, or by model role, or by WSA status or any of a number of things. 

In fairy tale dream land, I would also want this sorting on multiple columns at the same time (also as has been requested in various other places for modules) -- e.g. sort ascending on name then ascending on WSA status so that I have a nice group of alphabetically organized WSAs at the top then a nice group of alphabetically sorted non-WSAs below. 

EarlC

This would be extremely great.

tscott

It would be very convenient to be able to automatically re-order list items using an automatic sort (i.e. arrange list members alphabetically within a list).

 

If there are many items within a list and they are disordered it is frustrating to see this follow through into a format of a line item (say one used as a selector that an end user sees). 

 

With many list items it is impractical to manually rearrange them and if data is stored against those list items you can not delete and re-import, hence sorting within a list would be helpful.

 

Seems like an easy win to me.

Miran

Status changed to: Delivered

DavidSmith

needs to be merged with 

https://community.anaplan.com/t5/Idea-Exchange/Sorting-items-by-code-or-name-in-number-lists/idi-p/34843

 

 

DavidSmith

should be merged with https://community.anaplan.com/t5/Idea-Exchange/Sorting-items-by-code-or-name-in-number-lists/idi-p/34843

nick_barker

Think my idea has more detail and more functionality requirements...and refers to all lists not just numbered...

 

vicky_ascencio

Status changed to: Delivered

jprince

Is there any update on when we can expect something to be released? 

DavidSmith

@jprince 

Scheduled for the next release 😀- on 26th 

David

swoods93

Awesome!

JaredDolich

Big win @DavidSmith Very excited about this functionality.

Alessio_Pagliano

Nice one! I know it's only a few days away but what should we be expecting in terms of options and functionality ? 

DavidSmith

@Alessio_Pagliano 

It works in a similar way to Delete from list using a Selection.  You choose a line item (text or numeric) in a module dimensioned only by the list you want to sort.

You can then choose Ascending/Descending

So you can create as many actions as you want with different sort criteria and add them to processes if you want to 

Currently Admin only as Selective access for end users is tricky!

David

 

Alessio_Pagliano

Thanks @DavidSmith , successfully tested and working brilliantly!

jprince

@DavidSmith Thanks! This is awesome, and a huge win for a few of my projects!!

dafinkapancheva

Status changed to: Delivered