title: How can I filter a Sharepoint 2007 libarry list based on current user login?
body: <p>I would like to know how I can filter a SharePoint library list based on current user login.</p>
  
  <p>Suppose I have created the followings:
  1) A SharePoint form library containing bunch of uploaded InfoPath form data.
  2) The InfoPath form template contains a promoted text field called "TargetUser" to store user domain login (ex: DOMAIN\JOE) and every InfoPath form file in the library has a valid domain name stored in the "TargetUser" field.</p>
  
  <p>I have created a custom view for the form library and would like to filter this view so only items whose "TargetUser" field matches current user's login ID are displayed.</p>
  
  <p>I went to Edit View page to customize the view and tried to use the [Me] function but I got a "Filter value is not a valid text string" message instead when clicking OK.  Apparently [Me] returns a Person/Group data type and the filter cannot compare its value to that of "TargetUser".</p>
  
  <p>I tried using other text functions (ex: TEXT([Me],"") hoping to extract default string value from [Me].  The filter accepted the parameter without any error but the resulting fitlered list does not display any items at all.</p>
  
  <p>I have googled this subject but I have not found any solution.</p>
  
  <p>It would be greatly appreciated if anyone can help me to create a functional filtered list.
  And FYI, my SharePoint 2007 installation is just WSS 3.0 + Form Server.  I do not have MOSS 2007 (so no MOSS 2007 web parts or web services).</p>
  
  <p>Thank you.</p>
  
  <p>Jason</p>