Ordered List Action and How to Use and How to Order a List Subset

[JaredDolich]

Hi Anaplanners. Just a quick update on the Ordered List Action.

Great functionality - a game changer for many use cases. I will show you an example plus a way to reorder a list subset. I'm sure many of you will have a more creative way to order the list subset so please share!

First you have to create a module that uses the list, and only the list, that  you want to reorder. Add a line item that contains the order you wat - can be text or general number. 

Create a Order List Action that uses that line item for that list. You cannot select a list subset. It must be a module that uses the complete list.

Run the action. Success!

For List Subsets I created a module that uses the list subset and added a Boolean line item set to TRUE.

In the module that uses the complete list I lookup the Boolean from the module using the subset list, as shown.

Blueprint:

Create the Action using the Final Order to Use Line Item

The module using the list subset is now reordered.

[Misbah]

@JaredDolich 

Muchas Gracias, for taking time to put it out for wider audience.

[sean_culligan]

Thanks @JaredDolich , really helpful guide.

[DavidSmith]

The Anapedia page is now available

https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Order-list.html

David

[sean_culligan]

Hi David,

thanks for the list. In the Anapedia article it suggests you can sort on characters (a,b,c,d,e...) however when I tested a sort on a text formatted line item the sort did not work. It only worked on number (1,2,3,4...).

The example I used was a simple list of A-Z, then I created a module with one line item which returned Name(Item()), and I couldn't get the sort to work.

[Misbah]

@sean_culligan 

Do you mean to say that you changed the format of the line item from number to Text and updated it with formula and then it didn't work.  I did try that, it works just fine. One piece of advice is that if you have published your module and Order Action on dashboard then you will have to refresh the dashboard but if you go into the list directly it refreshes as soon as the process completes.

Misbah

[sean_culligan]

@Misbah @DavidSmith 

Right, that is odd, the sort is now working fine on text formatted line items. I must have done something silly when I tested before

This is what I was playing with:

1. Simple list (a-z), with a properties module which returns the name

2. Apply the sort on the name property.

[Alessio_Pagliano]

@sean_culligan

I had the same issue...I thought I did something wrong so I started from scratch and the second time it all worked just fine .

[TGagnon]

Do you have an updated link? The URL does not work.

[rob_marshall]

@TGagnon 

Try this link:

https://help.anaplan.com/7a09027d-894e-4817-9f92-1fd11d018e2a-Order-List