The following SQL script will list the properties along with the display order.
SELECT TOP 1000 [ProfileSubtypeID]
,[ProfileSubtypePropertyAttributes].[PropertyID]
,[PropertyList].[PropertyName]
,[PropertyList].[isSection]
,[DisplayOrder]
FROM [Profile DB].[dbo].[ProfileSubtypePropertyAttributes]
join [Profile DB].[dbo].[PropertyList] on propertyList.propertyid = [ProfileSubtypePropertyAttributes].propertyid where [ProfileSubtypeID] = 1
order by [DisplayOrder]
The script will give you a listing like this:
The following update script changes the display order of the property with the propertyID, 10013, to 5304. Note that the numbering for the DisplayOrder field does not have to be sequential. The screen shot above shows the property with the new display order value.
update [Profile DB].[dbo].[ProfileSubtypePropertyAttributes]
set DisplayOrder = 5304
where propertyID = 10013
You just saved me several hours of clicking and waiting for those incredibly slow buttons. THANK YOU!
ReplyDeleteYour welcome! I'm glad I could save you the agony of having to do this.
DeleteI used it in SharePoint 2013, worked perfectly, it's by far the easiest solution I've seen. But not everybody will be happy to change the database directly.
ReplyDeleteWorked for me, Thanks.
would render the SharePoint farm unsupported though, since writing around the SharePoint API is not supported by Microsoft.
ReplyDeleteIn the times that I have dealt with Microsoft's tech support they have never inquired into any changes I have done.
Delete