Why doesn't CAML Query Get Data from a Column Name?

Question

I have a custom list which I am pulling data from using JavaScript. However for some reason it does not pick up two columns when I call them by their name. I have to use console.log(collListItem.getItemAtIndex(0).get_fieldValues()) in the browser console to find the field values and use those names instead.

What's the reason why it won't pick up these columns? Shouldn't it always pick up the columns when called by name? My problem is that if the someone else wants to change the code they won't know where to look. I would like everything to be consistent.

function GetListItems(SPHostUrlKey){
    var SPContext = new SP.ClientContext.get_current(SPHostUrlKey);
    var web = SPContext.get_web();
    var List = web.get_lists().getByTitle("People List");

    var camlQuery = new SP.CamlQuery();
    camlQuery.set_viewXml('<View><Query><Where><Geq><FieldRef Name=\'ID\'/>' + 
        '<Value Type=\'Number\'>0</Value></Geq></Where></Query><RowLimit>10</RowLimit></View>');

    collListItem = List.getItems(camlQuery); 
    SPContext.load(collListItem);   
    SPContext.executeQueryAsync(GetListItemsSuccess, GetListItemsFail);
}

while (listItemEnumerator.moveNext()){

    var oListItem = listItemEnumerator.get_current();
    title = oListItem.get_item('Title');    //Title of Link
    caption = oListItem.get_item('p06v'); //This is internal name of the 'Caption' column
    url = oListItem.get_item('URL');        //URL of Links

    order = oListItem.get_item('nywb'); //This is internal name of the 'Order' column
    //order = oListItem.get_item('Order');

}//End of While Loop

Community · Accepted Answer · 2017-04-13 12:41:26Z

The functions GetListItemsSuccess and GetListItemsFail are missing in your script. But maybe you have intentionally let them away here. The while-clause has to be in the GetListItemsSuccess-function to retrieve the items:

function GetListItemsSuccess() {
    while (listItemEnumerator.moveNext()){

        var oListItem = listItemEnumerator.get_current();
        title = oListItem.get_item('Title');    //Title of Link
        caption = oListItem.get_item('p06v'); //This is internal name of the 'Caption' column
        url = oListItem.get_item('URL');        //URL of Links

        order = oListItem.get_item('nywb'); //This is internal name of the 'Order' column
        //order = oListItem.get_item('Order');

    }//End of While Loop
}

Once I had the problem that I had to set the ViewFields to get the items. So you can try to add the ViewFields-attributes into the camlQuery.set_viewXml:

camlQuery.set_viewXml("<View><ViewFields>" + "<FieldRef Name=\'Title\'/>" + "<FieldRef Name=\'p06v\'/>"  + "<FieldRef Name=\'URL\'/>" + "<FieldRef Name=\'nywb\'/>" + "</ViewFields></View>");

Another option would be to disable the CAML query and try to get all elements so that you are sure to get them first.

Edit: You can retrieve items from list if you are using the column name.

var fieldExist = false;
  while (e.moveNext()) {
   var field = e.get_current();
   if (field.get_title() == "myfieldname") {
     fieldExist = true;
   }
} return fieldExist;

Please refer to this post and its comments: How to retrieve items using column names

Yes I left out the success function on purpose. I don't want to use 'p06v' or 'nywb' for the column names, those are internal column names, I want to use the column names in the list, which are 'Caption' and 'Order'. — Mike Mendez
– Mike Mendez, Commented Nov 11, 2015 at 14:15

Stack Exchange Network

Why doesn't CAML Query Get Data from a Column Name?

1 Answer 1

Your Answer

Linked

Hot Network Questions

Why doesn't CAML Query Get Data from a Column Name?

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Linked

Related

Hot Network Questions