I have a SharePoint list and I need to get all items from that list without using CAML Query in JSOM.
How can I do this?
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this communityTry using your code something like below:
var oListItems;
function GetAllListItems() {
// You can optionally specify the Site URL here to get the context
// If you don't specify the URL, the method will get the context of the current site
// var clientContext = new SP.ClientContext("http://MyServer/sites/SiteCollection");
clientContext = new SP.ClientContext();
var oWeb = clientContext.get_web();
// Specify list title here
var oList = oWeb.get_lists().getByTitle("List Name");
// Get all list items from the list
// This method will get all the items from all the folders and sub folders including folders and sub folders too
oListItems = oList.getItems(SP.CamlQuery.createAllItemsQuery());
// Load list items to Client Context
clientContext.load(oListItems);
// Execute the query to the server.
clientContext.executeQueryAsync(onsuccess, onfailed);
}
function onsuccess() {
// Iterate through Enumerator
var oEnumerator = oListItems.getEnumerator();
while (oEnumerator.moveNext()) {
// get_item("ColumnName")
var oListItem = oEnumerator.get_current().get_item('Title');
console.log("Name : " + oListItem);
}
}
function onfailed(sender, args) {
console.log('Failed' + args.get_message() + '\n' + args.get_stackTrace());
}
Reference: Get All Items in SharePoint using JSOM.
<Query><OrderBy><FieldRef Name='ID' /></OrderBy></Query>