This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Learn More

Remove From My Forums

How is the relative list item order calculated from tp_ItemOrder column?

Question
0

Sign in to vote

Hello!

I am using a custom action and the Reorder.aspx page to provide a sorting-functionality to my users. I followed the instructions that can be found here: https://niftit.com/blog/how-to-reorder-a-sharepoint-custom-list/

I managed to order my list by the "Order" column. However, i also want to display the order value. I found out that the reordering mechanism uses the tp_ItemOrder column and that the values that are stored there are responsible for calculating the relative order in which list items are displayed.

So my question is: How is the relative order calculated? If I display the "Order" column in my view the values are for example 162.5, 325, 350, 400, 500, 750 and so on. How can i calculate a meaningful numeration (1, 2, 3, 4, ...) from the values in the "Order" column?

Thanks for your help!

Monday, February 15, 2016 12:55 PM

Answers

0

Sign in to vote
Hi Monica D,

How is the relative list item order calculated from tp_ItemOrder column, it is determined by the inner function in SharePoint 2010.

The number of order column grows from small to big, but there is no meaningful if you change the order many times. So you cannot calculated from the order column.

There are two workarounds.

1. You could create a number column and set the number manually, then order the list items by the number column. The number will be meaningful.

2. You could create event receiver. When the item is added or updated, you could get all values of the order column and compare these values, then set the meaningful number in a new column according to the sort. The workaround need some skills of development.

More references:

Creating SharePoint 2010 Event Receivers in Visual Studio 2010.

https://msdn.microsoft.com/en-us/library/office/gg252010(v=office.14).aspx

How to create a custom list level event receiver in SharePoint 2013 and SharePoint 2010.

http://www.sharepointpals.com/post/How-to-create-a-custom-list-level-event-receiver-in-SharePoint-2013-and-SharePoint-2010

How to: Read the Value of a Field in a List Item.

https://msdn.microsoft.com/en-us/library/office/ff521580(v=office.14).aspx

Best regards,

Sara Fan
TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.
- Proposed as answer by Victoria Xia Tuesday, February 23, 2016 8:00 AM
- Marked as answer by Victoria Xia Wednesday, February 24, 2016 8:28 AM
Tuesday, February 16, 2016 6:15 AM