How to change the Sitecore bucktable folder structure based on the months

Question

We need to modify the folder structure of bucktable items, Sitecore default short this based on the dates but how to setup this based on the months.

Example - The current folder structure is:

      2017  
                April
                February
                January

Expectation is 2017 January February March

Anyone know how to setup this type of structure

Answer 1

Unfortunately, there is no native way to sort the folders into sequential order unless you change the month folders to be digits, I.e. Change "January", "February"... to "01", "02"...

The reality is that unless you're having your users view item buckets, which is not recommended except in special circumstances, then they will never see those folders.

If your users are able to see the folders and you really have your heart set on sorting them then what you can do is add some custom logic that runs when an item is created that tests whether or not the item is a bucket folder (using Sitecore.Buckets.Extensions) and if so sets the _SortOrder field appropriately. You can either do this with an item:created or item:added event, or with a custom <addFromTemplate> pipeline processor. There are several examples of these online, so I won't repeat them here. As for the logic, you can use something like the following:

...

if (!item.IsABucketFolder()) 
{
    return;
}

var sortOrder = string.Empty;
switch(item.Name)
{
    case "January"
        sortOrder = "1";
        break;
    case "February"
        sortOrder = "2";
        break;
    ...
    default
        return;
}

using (new SecurityDisabler()) 
{
    item.Editing.BeginEdit();
    item[Sitecore.FieldIDs.SortOrder] = sortOrder;
    item.Editing.EndEdit();
}

...

Answer 2

There is no out of box method provided by Sitecore for this. You can create dictionary items based on month names and keep values as 1, 2, 3... for them . Then you can create a custom handler for item:created event and update the item _SortOrder field value from corresponding month dictionary item value.

Answer 3

After a lot of investigation and asked to Sitecore team, We have implemented this through below approach - Suggested by Sitecore support ticket.

Actually, there is no setting which can change the behavior of the sort order according to your needs.

As per current implementation, We have created a custom "BucketFolderPathResolver" class to generate the month names (e.g. January).

To resolve the requirement we have changed the folder structure and it works for us.

Resolution – We have added the number of the month to the names.

2017 01-January 02-February 03-March