6 lines
336 B
SQL
6 lines
336 B
SQL
--select * from gridaudits where contentid=41082
|
|
select distinct vn.foldername,dbo.ve_getshortpathfromcontentid(ga.contentid)
|
|
from gridaudits ga
|
|
join vefn_getversionitems('') vi on vi.contentid=ga.contentid
|
|
join vefn_getversionnames() vn on vn.versionid=vi.versionid
|
|
where userid='Michelle' --contentauditid --between 141940 and 141984 |