Request failed. Column 'Project Phase' does not exist. It may have been deleted by another user

Question

function fetchProjectData(projectName, callbackOnSuccess) {

    var clientContext = new SP.ClientContext("path to site");
    var oList = clientContext.get_web().get_lists().getByTitle('Project Overview');

    var camlQuery = new SP.CamlQuery();
    camlQuery.set_viewXml('<View><Query><Where><Geq><FieldRef Name=\'Title\'/>' + 
        '<Value Type=\'Text\'>'+projectName+'</Value></Geq></Where></Query><RowLimit>1</RowLimit></View>');
    this.collListItem = oList.getItems(camlQuery);

    clientContext.load(collListItem, 'Include(Project Phase, Project Manager, Start Date, End Date)');

function onQuerySucceeded(sender, args) {

    var listItemInfo = '';

    var listItemEnumerator = collListItem.getEnumerator();

    while (listItemEnumerator.moveNext()) {
        var oListItem = listItemEnumerator.get_current();

        var itemObject = {
            title: oListItem.get_item('Start Date')
        };
        callbackOnSuccess(itemObject);
    }

}

function onQueryFailed(sender, args) {

    alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace());
}

    clientContext.executeQueryAsync(Function.createDelegate(this, onQuerySucceeded), Function.createDelegate(this, onQueryFailed));        
}

I'm trying to retrieve data from a list element.

Code above returns the error:

Request failed. Column 'Project Phase' does not exist. It may have been deleted by another user. /projects/Lists/Project Overview

• This column exists.
• Project Phase is the internal name.
• It hasn't been renamed.
• Its a choice column.

Answer 1

Try this

function fetchProjectData(projectName, callbackOnSuccess) {
    var clientContext = new SP.ClientContext("path to site");
    var oList = clientContext.get_web().get_lists().getByTitle('Project Overview');
    var camlQuery = new SP.CamlQuery();
    camlQuery.set_viewXml('<View><Query><Where><Geq><FieldRef Name=\'Title\'/>' + 
        '<Value Type=\'Text\'>'+projectName+'</Value></Geq></Where></Query><RowLimit>1</RowLimit></View>');
    this.collListItem = oList.getItems(camlQuery);

    clientContext.load(collListItem, 'Include(Project_x0020_Phase, Project_x0020_Manager, Start_x0020_Date, End_x0020_Date)');
    clientContext.executeQueryAsync(Function.createDelegate(this, onQuerySucceeded), Function.createDelegate(this, onQueryFailed));
}

function onQuerySucceeded(sender, args) {
    var listItemInfo = '';
    var listItemEnumerator = collListItem.getEnumerator();
    while (listItemEnumerator.moveNext()) {
        var oListItem = listItemEnumerator.get_current();
        var itemObject = {
            title: oListItem.get_item('Start_x0020_Date')
        };
        callbackOnSuccess(itemObject);
    }
}

function onQueryFailed(sender, args) {
    alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace());
}