How with javascript? Read SharePoint list Items using javascript.

In this post , you learn to read list items, using javascript.


Prerequisites.

A sharepoint list:

SharePoint List Name : ItemsSharePoint
Fields:

• Title = Single line of text.
• TextColumn = Single line of text.

1. Insert a content editor webpart, into a principal page. (see next image).

2. Open new notepad and paste the next code.

Code.

 Read Items Title  
 <br/>  
 <INPUT TYPE="button" VALUE="Read Items" onClick="ReadItem()">  
 <script type="text/javascript">  
 var siteUrl = '/sites/ejemplossharepoint';  
 var ListItems;  
 function ReadItem()   
 {  
      var clientContext = new SP.ClientContext(siteUrl);  
      var oList = clientContext.get_web().get_lists().getByTitle('ItemsSharePoint');  
      var query = new SP.CamlQuery();  
      query.set_viewXml("<View><Query><ViewFields><FieldRef Name='Title' /></ViewFields><ViewFields><FieldRef Name='Title' /></ViewFields></Query></View>");  
      ListItems= oList.getItems(query);  
      clientContext.load(ListItems);  
      clientContext.executeQueryAsync(Function.createDelegate(this, this.Succeeded), Function.createDelegate(this, this.Failed));  
 }  
 function Succeeded() {  
  var listEnumerator = ListItems.getEnumerator();  
  while (listEnumerator.moveNext()) {  
   alert("Text of list item : " + listEnumerator.get_current().get_item("Title") + listEnumerator.get_current().get_item("TextColumn"));  
  }   
 }  
 function Failed(sender, args) {  
  alert('Error: ' + args.get_message() + '\nStackTrace: ' + args.get_stackTrace());  
 }  
 </script>  

3. Save the notepad in a document library as "CodeRead" and then copu Shortcut  (see next image).

4. Edit content editor web part, and paste the link into "content link".

5. Test.

easily.

Regards.
Oscar Miguel Dominguez Acevedo

Insert Item in SharePoint list using javascript

The next post show the way to insert an item in sharepoint list using javascript.

Pre Requisites.
one sharepoint list.

1. In the main page, insert a content editor

2. Now, in a notepad insert the next code

Code

 Item Title  
 <br/>  
 <input id="Text1" type="text"/>  
 <br/>  
 <INPUT TYPE="button" VALUE="CrearLista" onClick="createListItem()">  
 <script type="text/javascript">  
 function createListItem()   
 {  
   var siteUrl = '/sites/ejemplossharepoint';  
   var Context = new SP.ClientContext(siteUrl);  
   var oList = Context.get_web().get_lists().getByTitle('ItemsSharePoint');  
   var itemCreateInfo = new SP.ListItemCreationInformation();  
   this.oListItem = oList.addItem(itemCreateInfo);  
   oListItem.set_item('Title', document.getElementById('Text1').value);  
   oListItem.update();  
   Context.load(oListItem);  
   Context.executeQueryAsync(Function.createDelegate(this, this.Succeeded), Function.createDelegate(this, this.Failed));  
 }  
 function Succeeded()   
 {  
   alert('Item number:' + oListItem.get_id() + ' was created');  
 }  
 function Failed(sender, args)   
 {  
   alert('Error:' + args.get_message() + '\n' + args.get_stackTrace());  
 }  
 </script>  

3. Save the document as "Code".

4. Create a document library with the name CodeLibrary and add the file "Code".

5. Copy the file link.

6. Edit the content editor and paste the file link.

7. test and verify.

easily =D

Regards.

Oscar Miguel Dominguez Acevedo.