Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

WSS Data View Filtered by Domain User Name

  Asked By: Stephanie    Date: May 19    Category: Sharepoint    Views: 1831

I have created a SharePoint WSS Data View using FrontPage that connects
to an SQL data source. One of the columns in the data view is
"UserName" which is a list of domain user names such as
"MYDOMAIN\jdoe". What I need to be able to do is filter the
records in the data view by the username of the logged-in user.

Is there a way to retrieve the logged-in user's username in a data
view so that I can use it as a filter property on the "UserName"
column or will I have to create a custom web part in Visual Studio?



2 Answers Found

Answer #1    Answered By: Kalyan Pujari     Answered On: May 19

Make a view  where UserName = [Me]

Answer #2    Answered By: Isidro Berger     Answered On: May 19

I didn't fully read the first question. I'm not sure
this will work for a WSS DataView on a SQL server table/view. Maybe you
could import the db values into Sharepoint, and then build a Sharepoint
view on top. Keep us informed.

Didn't find what you were looking for? Find more on WSS Data View Filtered by Domain User Name Or get search suggestion and latest updates.