I have created a SharePoint WSS Data View using FrontPage that connectsto 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 therecords 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 dataview 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?
Make a view where UserName = [Me]
I didn't fully read the first question. I'm not surethis will work for a WSS DataView on a SQL server table/view. Maybe youcould import the db values into Sharepoint, and then build a Sharepointview on top. Keep us informed.