Get SPList items (by CAML query) using JavaScript in SharePoint Apps

Introduction

Today I will show how to get SPList Items by filtering using CAML query. Also this post includes how to get the data from a custom field.

Solution Background

I use JQuery.Deferred and Promise in order to achieve the success and failure of the asynchronous call. There are plenty of articles on the internet regarding JQuery.Deferred. Please see the Reference section for more on this.

Solution

1.   function query() {
2.  
3.             var camlQuery =
4.                 "<Where>" +
5.                 "<Neq>" +
6.                 "<FieldRef Name='CustomFieldOne' />" +
7.                 "<Value Type='Text'>Suhail Jamaldeen</Value>" +
8.                 "</Neq>" +
9.                 "</Where>";
10.  
11.             //Calling the method getListItemsByCAMLAsync.
12.             //Here the fail and done methods are from the deffered object which is returning.
13.             getListItemsByCAMLAsync('NameOfList', camlQuery, 'Include(DisplayName, Id, CustomFieldOne)')
14.                     .fail(function (e) {
15.                         alert((handeler.parseSPException(e)));
16.                     }).done(function (items) {
17.                         var enu = items.getEnumerator();
18.                         while (enu.moveNext()) {
19.                             var cu = enu.get_current();
20.                             var id = cu.get_id();//Read the Id
21.                             alert(id);
22.                             var prope = cu.get_fieldValues();//You can see the fields which you are retreiving
23.                             var initiator = cu.get_fieldValues().CustomFieldOne;//Readvalue from custom property (Single line)
24.                             alert(initiator);
25.                         }
26.                     });
27.  
28.         };
29.  
30.         //This returns a deferred object.
31.         function getListItemsByCAMLAsync(listName, query, fieldsFilter) {
32.             var def = $.Deferred();
33.             var clientContext = new SP.ClientContext();
34.             var oWeb = clientContext.get_web();
35.             var ol = oWeb.get_lists().getByTitle(listName);
36.             var qry = new SP.CamlQuery();
37.             qry.set_viewXml(query);
38.             var items = ol.getItems(qry);
39.  
40.             clientContext.load(items, fieldsFilter);
41.             clientContext.executeQueryAsync(function () {
42.                 def.resolve(items);
43.             },
44.                 function (a, b) {
45.                     def.reject(b);
46.                 });
47.             return def.promise();
48.         };

Reference

http://sharepoint.stackexchange.com/questions/69878/how-to-use-client-object-model-javascript-to-get-a-custom-user-profile-propert

http://api.jquery.com/category/deferred-object/

http://www.htmlgoodies.com/beyond/javascript/making-promises-with-jquery-deferred.html

Conclusion

Should say Melick (http://melick-rajee.blogspot.com) for the guide on SharePoint Apps.

Get SharePoint list properties using JavaScript Object Model

Introduction

I was developing a SharePoint App using SharePoint JavaScript Object Model which also called SharePoint ECMAScript Client Object Model. Today I will show how to retrieve basic properties from SharePoint list.

Solution

1. function getSPListProperties() {
2.  
3.           //Get the current context. Same as SPContext in server side
4.           var ctx = SP.ClientContext.get_current();
5.  
6.           //Get the web
7.           var web = ctx.get_web();
8.  
9.           //Get the list by its title
10.           var list = web.get_lists().getByTitle('Title of the List Instance');
11.  
12.           //Load the properties which we need
13.           ctx.load(list, 'Title', 'Id', 'Created', 'ItemCount');
14.  
15.           //Excecute the loded queries asyncronisly
16.           ctx.executeQueryAsync(Function.createDelegate(this, onQuerySucceeded), Function.createDelegate(this, onQueryFailed));
17.  
18.           //Success method
19.           function onQuerySucceeded() {
20.               alert(list.get_title());
21.               alert(list.get_id());
22.               alert(list.get_created());
23.               alert(list.get_itemCount());
24.           }
25.  
26.           //Falied method
27.           function onQueryFailed() {
28.               alert('failed');
29.           }
30.       }

 

Conclusion

Please note that when you get the list through the method web.get_lists().getByTitle('Title of the List Instance'); It doesn’t load all the properties like in server side. We have to explicitly load the properties which we need.
When you didn’t load for a property, and try to call the method in order to get the data it will throw an exception.

Reference:
http://msdn.microsoft.com/en-us/library/office/jj245759(v=office.15).aspx#constructors