How to request sharepoint list data?

Question

Does anyone know how to get Sharepoint list data using an SQL query based on a specific sharepoint user.

Answer 1

You cannot use , you must not use SQL to retrieve data from a SharePoint list. The most common way to do this is with the usual solution, in which you can use CAML (SPQuery) to retrieve data for list items (e.g. user created ones) http://msdn.microsoft.com/en-us/library/microsoft.sharepoint .spquery.aspx , otherwise you can open SharePoint services to get the same results http://msdn.microsoft.com/en-us/library/sharepoint/jj164060.aspx .

Answer 2

As long as SharePoint 2010 is pretty easy to pull out of SQL, if you have a list GUID

Look here

SELECT ud.tp_ID , ud.tp_ListId , ud.tp_Author , ud.nvarchar1 , ud.nvarchar2 , ud.nvarchar3 , ud.nvarchar4 , ud.nvarchar5 , ud.nvarchar6 , ud.nvarchar7 , ud.nvarchar8 , ud.nvarchar9 , ud.nvarchar10 , ud.nvarchar11 , ud.nvarchar12 , ud.* FROM dbo.UserData ud WHERE (ud.tp_ListId = '[{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}')