Skip to main content
added 8 characters in body
Source Link
san
  • 1.7k
  • 8
  • 28

Function GetSharePointList1() { context = SP.ClientContext.get_current(); oList = context.get_web().get_lists().getByTitle('SharePoint List 2'); var camlQuery = new SP.CamlQuery(); camlQuery.set_viewXml(query); items = oList.getItems(camlQuery); context.load(items);

Function GetSharePointList1() {
context = SP.ClientContext.get_current();
oList = context.get_web().get_lists().getByTitle('SharePoint List 2');
var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml(query);
items = oList.getItems(camlQuery);
context.load(items);

context.executeQueryAsync(
    Function.createDelegate(this, onSuccessSharePointList1),
    Function.createDelegate(this, onFail)
);
}
function onSuccessSharePointList1() {

    recNum = items.get_count();
  
  if(recNum != 0){
     var listItemEnumerator = items.getEnumerator();
     while(listItemEnumerator.moveNext()) {
            var oListItem = listItemEnumerator.get_current();
            
            $().SPServices({
            operation: "GetListItems",
            async: false,
            listName: "SharePoint List 2",
            CAMLViewFields: "<ViewFields><FieldRef Name='Worklocation'/></ViewFields>",
            CAMLQuery: "<Query><Where><Eq><FieldRef Name='Title'/><Value Type='Text'>" + ReferenceID + 
                                      "</Value></Eq></Where></Query>",
            completefunc: function (xData, Status) {
              $(xData.responseXML).SPFilterNode("z:row").each(function() {
                Worklocation = ($(this).attr("ows_Worklocation"));
                      
                    });
            }
            });
            
             s = ..... (display all in table format)

          $("#resultTable").append(s);
          i++;
        }
       }

Function GetSharePointList1() { context = SP.ClientContext.get_current(); oList = context.get_web().get_lists().getByTitle('SharePoint List 2'); var camlQuery = new SP.CamlQuery(); camlQuery.set_viewXml(query); items = oList.getItems(camlQuery); context.load(items);

context.executeQueryAsync(
    Function.createDelegate(this, onSuccessSharePointList1),
    Function.createDelegate(this, onFail)
);
}
function onSuccessSharePointList1() {

    recNum = items.get_count();
  
  if(recNum != 0){
     var listItemEnumerator = items.getEnumerator();
     while(listItemEnumerator.moveNext()) {
            var oListItem = listItemEnumerator.get_current();
            
            $().SPServices({
            operation: "GetListItems",
            async: false,
            listName: "SharePoint List 2",
            CAMLViewFields: "<ViewFields><FieldRef Name='Worklocation'/></ViewFields>",
            CAMLQuery: "<Query><Where><Eq><FieldRef Name='Title'/><Value Type='Text'>" + ReferenceID + 
                                      "</Value></Eq></Where></Query>",
            completefunc: function (xData, Status) {
              $(xData.responseXML).SPFilterNode("z:row").each(function() {
                Worklocation = ($(this).attr("ows_Worklocation"));
                      
                    });
            }
            });
            
             s = ..... (display all in table format)

          $("#resultTable").append(s);
          i++;
        }
       }
Function GetSharePointList1() {
context = SP.ClientContext.get_current();
oList = context.get_web().get_lists().getByTitle('SharePoint List 2');
var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml(query);
items = oList.getItems(camlQuery);
context.load(items);

context.executeQueryAsync(
    Function.createDelegate(this, onSuccessSharePointList1),
    Function.createDelegate(this, onFail)
);
}
function onSuccessSharePointList1() {

    recNum = items.get_count();
  
  if(recNum != 0){
     var listItemEnumerator = items.getEnumerator();
     while(listItemEnumerator.moveNext()) {
            var oListItem = listItemEnumerator.get_current();
            
            $().SPServices({
            operation: "GetListItems",
            async: false,
            listName: "SharePoint List 2",
            CAMLViewFields: "<ViewFields><FieldRef Name='Worklocation'/></ViewFields>",
            CAMLQuery: "<Query><Where><Eq><FieldRef Name='Title'/><Value Type='Text'>" + ReferenceID + 
                                      "</Value></Eq></Where></Query>",
            completefunc: function (xData, Status) {
              $(xData.responseXML).SPFilterNode("z:row").each(function() {
                Worklocation = ($(this).attr("ows_Worklocation"));
                      
                    });
            }
            });
            
             s = ..... (display all in table format)

          $("#resultTable").append(s);
          i++;
        }
       }
Source Link
san
  • 1.7k
  • 8
  • 28

I'm using Sharepoint 2013 in office 365. As using lookup will impact the current structure i have. In SPD 2013, is there any way to do data source merging, i can't find it anywhere.

I managed to use camlquery and spservices (GetListItem) in between to get the information from SharePoint list 2

Try this:

Function GetSharePointList1() { context = SP.ClientContext.get_current(); oList = context.get_web().get_lists().getByTitle('SharePoint List 2'); var camlQuery = new SP.CamlQuery(); camlQuery.set_viewXml(query); items = oList.getItems(camlQuery); context.load(items);

context.executeQueryAsync(
    Function.createDelegate(this, onSuccessSharePointList1),
    Function.createDelegate(this, onFail)
);
}
function onSuccessSharePointList1() {

    recNum = items.get_count();
  
  if(recNum != 0){
     var listItemEnumerator = items.getEnumerator();
     while(listItemEnumerator.moveNext()) {
            var oListItem = listItemEnumerator.get_current();
            
            $().SPServices({
            operation: "GetListItems",
            async: false,
            listName: "SharePoint List 2",
            CAMLViewFields: "<ViewFields><FieldRef Name='Worklocation'/></ViewFields>",
            CAMLQuery: "<Query><Where><Eq><FieldRef Name='Title'/><Value Type='Text'>" + ReferenceID + 
                                      "</Value></Eq></Where></Query>",
            completefunc: function (xData, Status) {
              $(xData.responseXML).SPFilterNode("z:row").each(function() {
                Worklocation = ($(this).attr("ows_Worklocation"));
                      
                    });
            }
            });
            
             s = ..... (display all in table format)

          $("#resultTable").append(s);
          i++;
        }
       }