I need a sql query that shows files created today, is that possible?
Shankaran,
Play around with this, there are a lot of different dates in the revisions table to try:
select Path + filename, r.Date from
Documents d
inner join DocumentsInProjects dp on d.DocumentID = dp.DocumentID
inner join Projects p on p.ProjectID = dp.ProjectID
inner join Revisions r on r.DocumentID = d.DocumentID and r.RevNr = 1
where DATEDIFF(HOUR, r.Date, GETUTCDATE()) < 24
Shankaran,
Play around with this, there are a lot of different dates in the revisions table to try:
select Path + filename, r.Date from
Documents d
inner join DocumentsInProjects dp on d.DocumentID = dp.DocumentID
inner join Projects p on p.ProjectID = dp.ProjectID
inner join Revisions r on r.DocumentID = d.DocumentID and r.RevNr = 1
where DATEDIFF(HOUR, r.Date, GETUTCDATE()) < 24