Datasheet view added programatically missing from view selector

Question

I am adding a new view to a list using CSOM (ViewTypeKind = Grid).

The same code works perfectly for other types of views.

For datasheet views, although they are added and they function properly, they are only available in the ribbon dropdown, not in the page context menu view selector.

The fact that other people are experiencing this makes me suspect of an issue in the API but perhaps there is something we can do to overcome this.

Adding the view manually through the UI works fine.

Similar thread:

List views of type Datasheet created in CSOM do not appear in the list's 'view selector'

About the View Selector (aka ClientPivotControl):

List View Web part not showing all available views for list

EDIT:

Here's a basic example in case anyone wants to give it a try.

BTW, it appears that this issue is not limited to CSOM. It happens the same when adding datasheet views from the server side.

param(
    $webUrl = "http://yourwebsite",
    $listTitle = "yourlisttitle",
    $viewTitle = "datasheet-test"
)

$web = get-spweb $webUrl
$list = $web.Lists[$listTitle]
$view = $list.Views.Add($viewTitle, "Name", "", 50, $true, $false, "GRID", $false)

Answer 1

Hmmm, i tried the below mentioned code and it works. It's created in CSOM.

List taskList = currentWeb.Lists.GetByTitle("Tasks");

                // Get all the view  
                //for the custom list  
                ViewCollection viewColl = taskList.Views;

                // Specify the columns that should be displayed
                string[] viewFields = { "ID", "LinkTitle", "StartDate", "DueDate", "AssignedTo", "Status", "Body" };

                // Specifies the properties used to create a new list view    

                ViewCreationInformation creationInfo = new ViewCreationInformation();
                creationInfo.Title = "All my custom Tasks";
                creationInfo.RowLimit = 30;
                creationInfo.ViewFields = viewFields;
                creationInfo.ViewTypeKind = ViewType.Grid;
                creationInfo.SetAsDefaultView = false;
                viewColl.Add(creationInfo);
                context.ExecuteQuery();

Answer 2

This solution works for me with update ViewTypeKind like creationInfo.ViewTypeKind = ViewType.Grid | ViewType.Html; using CSOM

     List taskList = currentWeb.Lists.GetByTitle("Documents");

        // Get all the view  
        //for the custom list  
        ViewCollection viewColl = taskList.Views;

        // Specify the columns that should be displayed
        string[] viewFields = { "ID", "LinkFilename", "Title", "Editor" };

        // Specifies the properties used to create a new list view    

        ViewCreationInformation creationInfo = new 
        ViewCreationInformation();
        creationInfo.Title = "DataSheet by Selva";
        creationInfo.RowLimit = 30;
        creationInfo.ViewFields = viewFields;
        creationInfo.ViewTypeKind = **ViewType.Grid | ViewType.Html;**
        creationInfo.SetAsDefaultView = false;
        viewColl.Add(creationInfo);
        ctx.ExecuteQuery();

Answer 3

So time is running out and I don't see any solution for this.

User gautam pointed me in the right direction, which is why I am giving him the bounty, but I want to post the actual answer myself.

This is clearly a bug in the SP2013 version of the view selector functionality, which is setup in the actual webpart, not the view.

I'd also like to point out that this issue is not limited to SSOM or CSOM, it happens in both and it also happens in various types of views, such as Datasheet and Calendar, probably others.

The workaround is to trigger an update on the DisableViewSelectorMenu webpart property, which can be achieved by manually editing the view webpart through the user interface, or programatically updating the property and the webpart, as shown below.

public void FixWebPartViewSelector(ClientContext context, string listTitle, string viewFileName)
{
    Web web = context.Web;
    List list = web.Lists.GetByTitle(listTitle);
    context.Load(list, l => l.RootFolder);
    context.ExecuteQuery();

    string pageUrl = list.RootFolder.ServerRelativeUrl + "/Forms/" + viewFileName;

    Console.WriteLine("Fixing view selector in: " + pageUrl);

    File file = web.GetFileByServerRelativeUrl(pageUrl);
    PersonalizationScope scope = Microsoft.SharePoint.Client.WebParts.PersonalizationScope.Shared;
    LimitedWebPartManager wpm = file.GetLimitedWebPartManager(scope);

    context.Load(wpm);
    context.Load(wpm.WebParts);
    context.ExecuteQuery();

    int numWebparts = wpm.WebParts.Count;

    Console.WriteLine("Found " + numWebparts + " webparts!");
    if(numWebparts == 1)
    {
        WebPartDefinition wpd = wpm.WebParts[0];
        WebPart wp = wpd.WebPart;

        //PrintWebpartProperties(context, wp);

        //update view selector
        wp.Properties["DisableViewSelectorMenu"] = false;

        //commit
        wpd.SaveWebPartChanges();
        context.ExecuteQuery();
    }    
}

USAGE:

FixWebPartViewSelector(context, "Documents", "AllItems.aspx");

See also

(Calendar) list views disappear from view selector menu of list view webpart

Programmatically created calendar view does not appear on view selector menu