UserID Element (View)
Contains the unique ID number of the currently authenticated user of a site, as defined in the UserInfo table of the content database.
The UserID element can be used to compare the value of a field to the current user ID. If the request is anonymous, this element, by default, causes the server to force authentication, which means it must display a dialog box in the browser that asks for a password or else it must initiate Windows NT challenge/response (NTLM). If a user has accounts on multiple subsites or Web applications, the user ID may be different in each case.
The following query returns cases where either the Author or Editor field is equal to the current value of the UserID element, and it returns the results in ascending order with the Title field first, and then the FirstName field.
<Query> <Where> <Or> <Eq> <FieldRef Name="Author" /> <Value Type="Integer"> <UserID /> </Value> </Eq> <Eq> <FieldRef Name="Editor" /> <Value Type="Integer"> <UserID /> </Value> </Eq> </Or> </Where> <OrderBy> <FieldRef Name="Title"> </FieldRef> <FieldRef Name="FirstName"> </FieldRef> </OrderBy> </Query>