I want to get the row count of a list using JSOM but I am not able to get it.
Can any one help ?
The code am using is as below:
function retrieveBookingDetails(BDate) {
var ctx = new SP.ClientContext(appWebUrl);//Get the SharePoint Context object based upon the URL
var myList = ctx.get_web().get_lists().getByTitle("MyList");
var query = new SP.CamlQuery();
query.set_viewXml('<View><Where><eq><FieldRef Name=\'EventDate\'/><Value Type=\'DateTime\'IncludeTimeValue=\'FALSE\' >' + BDate + '</Value></eq>" + "</Where></View>');
var items = myList.getItems(query);
ctx.load(items);
ctx.executeQueryAsync(onQuerySucceeded, onQueryFailed);
function onQuerySucceeded() {
retrieveItems(items);
}
function onQueryFailed(sender, args) {
alert('Request failed. ' + args.get_message() +
'\n' + args.get_stackTrace());
}
function retrieveItems(items) {
var enumerator = items.getEnumerator();
var count = 0;
var count = items.get_count();
while (enumerator.moveNext()) {
//am generating HTML here
}
}
myList.get_itemCount();
will give you total items/rows in the list.items.get_count()
will give you total items/rows returned by your CAML query