0

I have set up an async query in javascript. I am able to send a list item and get the column values back. However, is there any way to send the webpart object itself or an entire list object so that I can process multiple items.

Here is what I have that works;

<script type="text/javascript">

function clickMethod_Mailto() {

  var ctx = SP.ClientContext.get_current();
  var listId = SP.ListOperation.Selection.getSelectedList(ctx); //selected list Id
  var items = SP.ListOperation.Selection.getSelectedItems(ctx); //selected Items Ids
  var list = ctx.get_web().get_lists().getById(listId);

  var i;

  mailto ='';
   for (i in items)
   {
     targetListItem = list.getItemById(items[i].id);
     ctx.load(targetListItem);
     ctx.executeQueryAsync(Function.createDelegate(this, this.OnSuccess), Function.createDelegate(this, this.OnFailure));
  }

}

function OnSuccess() {
  alert(targetListItem.get_item('Mailto'));  
}

function OnFailure() {
 alert('Request failed. \nError: ' + args.get_message() + '\nStackTrace: ' + args.get_stackTrace());
}


</script>

<input id="clickMe" type="button" value="E-Mail Selected" onclick="clickMethod_Mailto();" />

However, I run into the problem that the async query will run multiple times. I want to put the loop part inside the async call using something like;

ctx.load(ctx);

But this fails.

So what can I pass to an async call? Are there any limits on what can or can't be passed via the .load method.

This is related to a my previous question here but using a different approach to the one I requested help on.

Any help gratefully appreciated.

  • Please check here link Hope this helps. – Anupam Jagatdeo May 14 '18 at 11:18
  • @AnupamJagatdeo this looks just what I need but I am struggling with its implementation. I have a button that calls my javascript. <input id="clickMe" type="button" value="E-Mail Selected" onclick="clickMethod_Mailto();" /> How do I call the getSelectedItems().then(function(items){..}? – unibod50 May 14 '18 at 13:37
  • 1
    Try building a CAML query in the for loop and then using that to get all the items you need in a single executeQueryAsync. Alternatively, try using REST instead of JSOM. Building the $filter would be a lot more simple than a CAML query. – wjervis May 14 '18 at 15:00
1

I have managed to get it all working by some trial and error and a trawl of the web.

<script type="text/javascript">
function getMailto() {

      var ctx = SP.ClientContext.get_current();
      var splist = ctx.get_web().get_lists().getByTitle("LU_Mailto");
      var items = SP.ListOperation.Selection.getSelectedItems(ctx); //selected Items Ids

      var i;

      //Construct the CAML query using ids of items selected
      var qryString ="<View><Query><Where><In><FieldRef Name='ID' /><Values>";
      for (i in items)
      {
        qryString = qryString + "<Value Type='Integer'>" + items[i].id + "</Value>";
      }
      qryString = qryString + "</Values></In></Where></Query></View>"

      //Generate the CAML query
      var query = new SP.CamlQuery();
      query.set_viewXml(qryString);
      this.qryItems = splist.getItems(query);

      //Load CAML query and run Async
      ctx.load(qryItems);
      ctx.executeQueryAsync(Function.createDelegate(this, OnSuccess), Function.createDelegate(this, OnError));

    }

    function OnSuccess() {

      //Construct the mailto string from caml query results
      mailto = '';
      for (var j = 0; j < qryItems.get_count(); j++) {
         mailto = mailto + qryItems.itemAt(j).get_item('Mailto') + ';';
      }
      //Open the outlook application with the To = mailto          
      window.location.href = "mailto:" + mailto;
    }

    function OnError() {
    alert("Failure");
    }

    </script>

    <input id="clickMe" type="button" value="E-Mail Selected" onclick="getMailto();" />
0

I guess something like this should work:

function clickMethod_Mailto(){
var dfd = $.Deferred(function () {
   var context = SP.ClientContext.get_current();
   var listId = SP.ListOperation.Selection.getSelectedList();
   var selectedItemIds = SP.ListOperation.Selection.getSelectedItems(context);
   var list = context.get_web().get_lists().getById(listId);
   var listItems = [];
   for (idx in selectedItemIds)
   {
      var item = list.getItemById(parseInt(selectedItemIds[idx].id));
      listItems.push(item);
      context.load(item);
   }
   context.executeQueryAsync(
     function() {
        dfd.resolve(listItems);
     },
     function (sender, args) {
           dfd.reject(args.get_message());
     }
   ); 
});return dfd.promise();
}
clickMethod_Mailto().then(function(items){
var mailTo;
for (var i =0 ; i < items.length;i++)
{
 mailTo += items[i].get_item('Title') + ";";
}
}); 

Have a try and let me know

  • Hi unibod50, glad to know you got it working :) – Anupam Jagatdeo May 15 '18 at 16:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.