Recently I needed to create List View that returns all items Created by Me. Creating this View trough SharePoint List UI is very simple. You simply add [Me] token in the query value text box. But, I need to create this View declarative in Schema.xml. This requires creating the query in CAML and that gave me little trouble. Thanks to latest VS2010 SharePoint project templates intelligence, I found that the Author field is of type “User” and that [Me] token is used as node <UserID />. Also [Today] token is used as <Today /> in CAML queries.
So here is CAML Query with [Me] token:
<FieldRef Name="Author" />
<Value Type="User"><UserID /></Value>
Thank you so much.. Ya it works and also save my time....