Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 831091 - Last Review: October 16, 2007 - Revision: 2.4
You cannot specify the logon username for a Data View Web Part filter in FrontPage 2003
When you add a Data View Web Part to a Microsoft Windows
SharePoint Services list, and then you create a filter for that Data View that
compares the
Created by field with the logon username in the
form of
"
domain\
username", it
returns no values for that filter criteria even if the current user matches
this criteria.
This problem occurs because the
Created by
field compares the "friendly" name version of the username and not the logon
username.
To work around this problem, you can force the filter to use
the logon username. To do so, follow these steps:
- On the Data menu, click
Filter.
- Click Click here to add a new
clause.
- Click Created by in the Field
Name column.
- Click Equals in the
Comparison column.
- Click [Current User] in the
Value column.
- Click OK.
- In the lower right corner of the edit window, click
Code.
- On the Edit menu, click
Find.
- Type Name="UserID"
Location="CAMLVariable" in the Find What box, and
then click Find Next.
- This will find the following line of HTML code:
<ParameterBinding Name="UserID" Location="CAMLVariable" DefaultValue="CurrentUserName"/>
- Change the line of HTML code to the following:
<ParameterBinding Name="UserID" Location="ServerVariable(LOGON_USER)" DefaultValue="[ LOGON_USER ]"/>
- Save the page, and then click Preview at
the bottom of the edit window.
Note These steps assume that you already have created a Data View in
an Announcement list. To create a Data View, follow these steps:
- Click the page where you want your Data View to
reside.
- On the Data menu, click Insert
Data View.
- Click the Windows SharePoint Services list that you want to
use as your data source.
- Click Insert Data View.
For more information about how to use server variables,
visit the following MSDN Web site:
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section of this article.
APPLIES TO
- Microsoft Office FrontPage 2003
- Microsoft Windows SharePoint Services 2.0
| kbwebpublishing kbhtml kbfilters kbprb KB831091 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate