Sharepoint Use SP.Camlquery() in jquery

Question

I am having a list Objectives with column STATUS and Reason

I used

  <script language="ecmascript" type="text/ecmascript">


     ExecuteOrDelayUntilScriptLoaded(ViewItem, "sp.js");
function ViewItem()
 {
 var context = new SP.ClientContext.get_current();
 var web = context.get_web();
  var list = web.get_lists().getByTitle('Objectives');

 var query = SP.CamlQuery.createAllItemsQuery();
 allItems = list.getItems(query);
  context.load(allItems, 'Include(STATUS)');
                                   context.executeQueryAsync(
         Function.createDelegate(this, this.success),          Function.createDelegate     
    (this, this.failed));
       }

           </script>

I need Only Status column to be fetched.I need camlquery and i dont know where to write.

Answer 1

Please refer below code snippet it might help you

enter code here

 function viewItem() {
    var clientContext = new SP.ClientContext.get_current();
    var web = clientContext.get_web();
    var list = web.get_lists().getByTitle("Sample");
    var camlQuery = new SP.CamlQuery();
    var q = '<View><Query><Where><Eq><FieldRef Name="ID" /><Value Type="Text">10</Value></Eq></Where></Query></View>';
    camlQuery.set_viewXml(q);
    this.listItems = list.getItems(camlQuery);
    clientContext.load(listItems, 'Include(Status,othercolumns)');
    clientContext.executeQueryAsync(Function.createDelegate(this, onItemsLoadSuccess), Function.createDelegate(this, onQueryFailed));
}
function onItemsLoadSuccess(sender, args) {
}

function onQueryFailed(sender, args) {
}`enter code here`