Click here to Skip to main content
15,888,351 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have a list 'NewsList' with columns Title, ShortDescription,Image ,Programs,Division and Tag.

Here, Programs,Division and Tag are lookup fields with same list name. When I try to retrieve the values, Title and ShortDescription are coming fine. But in Image, Programs,Division and Tag, its displaying [object Object]. I am a beginner to SharePoint and NAPA. Kindly help.

Below is the snippet of the codes I am using.

JavaScript
function getitems() {
 var hostUrl = decodeURIComponent(getQueryStringParameter("SPHostUrl"));
 var context1 = new SP.ClientContext.get_current();
 hostcontext = new SP.AppContextSite(context1, hostUrl);
 web = hostcontext.get_web();

 var selectedList = "NewsList";
 var selectedListTitle = web.get_lists().getByTitle(selectedList);  
 var camlQuery = new SP.CamlQuery();
 camlQuery.set_viewXml("<View><ViewFields>" +
                       "<FieldRef Name='Title' />" +
                       "<FieldRef Name='ShortDescription' />" +
                       "<FieldRef Name='Image' />" +
                       "<FieldRef Name='Programs' />" +
                       "<FieldRef Name='Division' />" +
                       "<FieldRef Name='Tag' />" +
                       "</ViewFields></View>')");
 listItemCollection = selectedListTitle.getItems(camlQuery);
 context.load(listItemCollection, "Include(Title, ShortDescription, Image, Programs, Division, Tag)");
 context.executeQueryAsync(onGetItemsSuccess, onGetItemsFail);
}

function onGetItemsSuccess(sender, args) {
  var listItemEnumerator = listItemCollection.getEnumerator();

  var strTbl = '';
  strTbl = strTbl + '<table><tr><td>Title</td><td>ShortDescription</td><td>Image</td><td>Programs</td><td>Division</td><td>Tag</td></tr>';

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


    strTbl = strTbl + '<tr><td>' + oListItem.get_item('Title') + '</td><td>' + oListItem.get_item('ShortDescription') + '</td>' + '<td>' + oListItem.get_item('Image') + '</td> +
                        '<td>' + oListItem.get_item('Programs') + '</td><td>' + oListItem.get_item('Division') + '</td>' +
                        '<td>' + oListItem.get_item('Tag') + '</td></tr>';
}
strTbl = strTbl + '</table>';
  $('#dvNews').html(strTbl);
 }


Kindly Help.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900