I have two lists which will be used to keep a log of changes in some data:
ChangeLog:
- Title
- Event
- Created By
- Other stuff
ChangeLogDetails:
- Id of related record in the ChangeLog list
- What was changed
- Old Value
- New Value
For each record in ChangeLog
, the ChangeLogDetails
list will contain one or more records, recording each column changed by user in some data.
I need to present a report that will combine the data from both lists. Each row must look like this:
ChangeLog.Title | ChangeLog.Event | [array of ChangeLogDetails.WhatWasChanged WHERE ChangeLogDetails.RelatedID = ChangeLog.ID]
It seems that this is impossible to do with SharePoint REST API, because there is no syntax to merge data from two lists. Am I correct?
Would it be possible to do this with CSOM? (I know nothing about it)