To be able to use an action to change the order of items in a list

To be able to use an action to change the order of items in a list

Description of the enhancement required:
To be able to use an action to change the order of items in a list.

 

An example of the enhancement:
I have a list, FRED, which is populated from a SQL query containing an ORDER BY clause. However, new items are always inserted at the end of the list (or rather, at the end of the items within the relevant parent item). The field I want to sort the list by is available in the data so I'd like to be able to run an action to sort the items within my list according to that field. I've tried creating a module view that orders the items by the relevant field but when I insert from this view it has no effect.

I can sort the list manualy but that doesn't solve the problem because it doesn't create an action that I can include in my processes. I want to be able to do it from the Import button, which would support this type of automation.

 

How would it help the business process:
This information is mostly given above, except to say that the reason I want to sort the items is that I'd like them to appear in their logical order in the page selector. It's simple enough in module views on dashboards, because I can apply a sort to the views, but page selectors always list items in their native order. I also don't want to have to delete the items and then reinsert them because there's too much data attached to them that would be lost.

2 Comments
AnaplanIdeas
Community Manager
 
Status changed to: Considered for Future Roadmap
stephen.brook
Contributor

The ability to run an action to Order list items was delivered in our September 2020 platform release: https://help.anaplan.com/en/7a09027d-894e-4817-9f92-1fd11d018e2a-Order-List-action

 

You can perform a List import in the usual way, and then add a new Order List action to your Process that enforces the sort order you wish to apply. You will probably need to add an extra step to your Import to import the field you wish to use as your sort key into a new line item.

Status changed to: Delivered