Compare sharePoint web site login ID with a column value in sql table using sql query

Question

Hi ALL,

I want to get the login ID of a sharepoint web site and compare the login id with a column value in the table using sql query without using any coding language. My scenario is to develop a BDC list in MOSS 2007 and deploy in a MOSS 2007 site. In the BDC list it has to retrive the tickets data from the sql based on the user login column in the table. Could any one solve this problem. Thanks in advance.

Regards,
Kishore

---

Kishore

Answer 1

Hi Kishore,

You may try to use Current User Filter Web Part.  The current user filter, which ships as a standard SharePoint web part, recognizes the user who requested the web page, and passes that user's name to one or more web parts on the same web page. Please take a look at this video SharePoint 2007: Filter Data with the Current User Filter

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts

Answer 2

Hi Dmitry,

Thank you for your solution. It is working fine. But i want to know is there any other way is to know the current user of the web site without using current user filter webpart. By using SQL Server, to filter the data by using current user.

Thanks & Regards,
Kishore

---

Kishore

Answer 3

Hi Kishore,

I suppose that other way is programming approach.

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts