How to Join two lists Using JSOM?

Question

Arvind Kushwaha · Answer

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 Ch · Answer

Thanks Aravind, I know this solution so I am searching for any better solution

Bhargava Ch · Answer

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 Kushwaha · Answer

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/

How to Join two lists Using JSOM?

Answers (4)