I would like to know, is there a way to build such a CAML Query, or is this nonsense:
I have a SharePoint List with two ContentTypes:
The Fields are
- ServiceGroup [MultiLookup to Service]
- Service[Lookup to ServiceGroup]
ServiceGroup can contain many
Services. For ServiceGroups and Services many Persons could be responsible.
For this given list I want to select with a
CAML Query all ListItems of
ContentType ServiceGroup for which person
'ABC' is responsible AND
all Services, which are
"Children" of the
ServiceGroups, selected within the first Query part, regardless of whether person 'ABC' or someone else is responsible for them.