My project consists of two lists:
- a list of documents. This list has an SPUser field that determines who is responsible for that document.
- a list of projects. This list has a multiple lookup to the documents (among other things).
The goal is to create a view on the projects list that shows only those projects that contain documents for which the current user is responsible. I'm having a very hard time finding examples of such things online. Here's what I have so far.
<Query> <Where> <Contains> <FieldRef Name="PROJ_Documents" /> ???? //not sure what to put here <Where> <Eq> <FieldRef Name="DOC_Responsible" /> <Value Type="Text"> <UserID/> </Value> </Eq> </Where> </Contains> </where> </Query>