How to Join two lists Using JSOM?

Bhargava Ch

6y935

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhargava Ch6y ago
Thanks Aravind, I know this solution so I am searching for any better solution
Arvind Kushwaha6y ago
Hi Bhargava,

As join is not working in some of the scenarios, Then definately we can do one think to get the above results.

Make two seperate call to sharepoint list and store the result in two different array and then filter the data according to our requirement.

const array1 = result of sharepoint 1 call

const array2 = result of sharepoint 2 call
const array3  = [];
array1.filter(item1 = >{
      array2.filter(item2 = >{
      if(item1.Id === item2.Id) {
         array3.push(item1);
       }
   });
});
Now array3 will have our desired results.
Hope this helps you.
Bhargava Ch6y ago
2 and 3 options are not useful 3 is csom 2 I know we need to get all the lists and use join 1 it is not working in some of the scenario
Arvind Kushwaha6y ago
Hi Bhargava,

Please check this links

https://sharepoint.stackexchange.com/questions/229474/how-to-join-two-lists-by-lookup-column-in-sharepoint-onlin

https://stackoverflow.com/questions/29002978/how-to-get-multiple-lists-using-jsom-in-sharepoint

https://www.ilikesharepoint.de/2012/12/sharepoint-2010-join-2-lists-by-using-caml/