Forum Discussion
Can't make simple LEFT or INNER Joins working on SharePoint Online
Hello! I have a problem and asking for help so any comments will be very valuable to me. At this point I really can't make simple LEFT or INNER Joins working on SharePoint Online, this is a r...
Hi, first of all thank you to all that spend time reading my post.
Here are my conclusions.
1. This site collection is a result from a on premise migration;
2. One thing that keep my eyes, was I have exactly the same number of records in all lists.
The problems:
Who migrated don’t keep in mind the items IDs, so all lookups query wrong information relative to other lists.
Even with the same records, there are duplicates and missing items.
The content types are in the wrong order.
Finally of course the Caml Query results are wrong. The scope of this post was just to double check what I was missing.
Thanks to all
Here are my conclusions.
1. This site collection is a result from a on premise migration;
2. One thing that keep my eyes, was I have exactly the same number of records in all lists.
The problems:
Who migrated don’t keep in mind the items IDs, so all lookups query wrong information relative to other lists.
Even with the same records, there are duplicates and missing items.
The content types are in the wrong order.
Finally of course the Caml Query results are wrong. The scope of this post was just to double check what I was missing.
Thanks to all