mardi 3 mars 2015

Retrieve list value with more than 2 look up field



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.



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.








0 commentaires:

Enregistrer un commentaire