I am creating a windows form application , in which user selects document library and after clicking on button I am creating an excel file which displays all document name with its metadata information.
The select query which I am querying to SQL Server is:
DECLARE @listId AS UNIQUEIDENTIFIER = 'c8508816-a7fb-43f1-82d1-62d79cbaf8e6';
DECLARE @fileNameFilter AS VARCHAR (250) = NULL;
DECLARE @dirFilter AS VARCHAR (250) = NULL;
SELECT DISTINCT
d.Id AS 'FileId',
d.WebId AS 'WebId',
d.SiteId AS 'SiteId',
d.DirName AS 'DirName',
d.LeafName AS 'FileName',
ISNULL(d.Size,0) AS 'Size',
d.UIVersion AS 'UIVersion',
ISNULL(d.InternalVersion,0) AS 'InternalVersion',
ISNULL(d.ETagVersion,0) AS 'ETagVersion',
d.Type as 'Type',
aud.tp_Created AS 'Created',
ui.tp_Login AS 'CreatedBy'
FROM AllDocs AS d
INNER JOIN
AllUserData AS aud
ON d.Id = aud.tp_DocId
INNER JOIN
UserInfo AS ui
ON aud.tp_Author = ui.tp_ID
WHERE d.ListId = @listId
AND (@fileNameFilter IS NULL
OR d.LeafName LIKE '%' + @fileNameFilter + '%')
AND (@dirFilter IS NULL
OR d.DirName LIKE '%' + @dirFilter + '%');
By using this query I am able to get the file name, its directory name, version but I want to fetch all data like custom fields with this query. I don't know which table to query for custom fields and content type fields.
Please help.
