I want to filter my list based on Current User and filter another view based on the Manager.
To filter for current user i used this :
<Query> <OrderBy> <FieldRef Name="Modified" Ascending="FALSE"> </FieldRef> </OrderBy> <Where> <Eq> <FieldRef Name="Author" /> <Value Type="Integer"> <UserID /> </Value> </Eq> </Where> </Query>
To filter based on another user which is not the current one , what type of field should i use ? I have the login name of the user and email. Do i need to get somehow the id and compare it with UserID ? What type is UserID?